SQL Developer


Certain data columns not showing up during a query


I have having trouble seeing certain data types when I search in Oracle SQL developer. Fields such as Dates and numeric values are showing as blank when I run a query. If I run the same query in SQL Plus, date values and numeric values appear. 
Please provide versions for
Sql Dev
Database
Java
OS
Also please post the simplified select statement.
-Raghu 
I am using SQL developer 2.1, but this was also happening when I was using early versions such as 1.5.5
THe Database is an oracle 11g database
on my machine I have an instance of java 1.5.0_18 running but within the application there is a java 1.6, I am not sure if the 1.6 is executing the program or not.
WIndows XP service 2002 service pack 3
Edited by: user9958587 on Jan 7, 2010 3:27 AM
SELECT * FROM AsAddress which will return our address table containing dates.
Edited by: user9958587 on Jan 7, 2010 3:27 AM 
Can you please post the DDL for this table ?
I am assuming that only this table in not displaying in the grid.
-Raghu 
What is the DDL? sorry I am not the most techincal of users.
Actually it is all tables within the Schema, Both Dates and Numeric values are not showing up in columns during query serachs. Text or VarChar seems to be ok. 
user9958587 wrote:
I am using SQL developer 2.1, but this was also happening when I was using early versions such as 1.5.5So the dates and numbers did not display on different versions of the product. Odd.
I assume the values do not appear in the grid when you run queries as querys. Do they appear when you use "run as script"? 
I ran these statements and it seemed to fix the problem
alter session set nls_sort=binary;
alter session set nls_comp=binary;
I am not sure why that was happening, I appriciate you trying to help me out though. Thanks 
What did you have then in Preferences - Database - NLS? 
This is what is there now:
Language: American
Territory: American
Sort: Binary
Comparison: Binary
Date Language: American
DateFormat: DD-MON-RR
Timestamp Format: DD-MON-RR HH.MI.SSXFF AM
Timestamp TZ Format: DD-MON-RR HH.MI.SSXFF AM TZR
Decimal Separator: .
Group Separator: ,
Currency $
ISO Currency: America
Length: BYTE 
And that doesn't work until you do the ALTER SESSION? Then there's something wrong...
K.

Related Links

Grant debug problems
2.1 EA1/EA2/RC1: Edit - Wrap Selection entry not enabled in worksheet
Need help with the Merge statement in Oracle 9i
Concurrency
Debugging, and autocommit
2.1 EA1: Can not see Indexes on Materialized Views
My SQL to Oracle Migration
PL/SQL compile shortcut key
Meening of Geen Bug in SQL Developer 2.1.0.62
How to export query results automatically each time to a saved path
insider for raptor don't work on sql developer  2.1
2.1 EA1 Bug: Worksheet Keyboard/Screen lag when default path is set
Locking/marking packages?
Formatting code -  To align fields of a query
2.1 EA1 User Defined Report problem
NoClassDefFoundError

Categories

ORACLE DEV
Oracle Community (OTN)
XML
Database Connectivity
Database Mobile Server...
Data Warehousing
iSQL*Plus [ARCHIVE]
TopLink/JPA
Advanced Planning & Sc...
UIX
Life Sciences Database...
XQuery
Oracle By Example (OBE)
Integration - General
Oracle Database Expres...
OC4J (Korean)
Spatial (Korean)
Performance Tuning (Ko...
Web Service Manager (K...
Discoverer (Korean)
Communications Service...
Planning and Budgeting
Enterprise Service Bus...
e-Manager Enterprise
Business Intelligence ...
Oracle on Amazon Web S...
Hyperion DRM/Analytica...
Archived BEA Dev2Dev F...
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
WebLogic Portal Newsgr...
Tuxedo Newsgroups
ALUI CodeShare
weblogic.eventserver.cep
Industries
Primavera Portfolio Ma...
SOA & Web Services (Ch...
BEA活动
Complex Event Processing
Oracle Solaris
Java EE (Java Enterpri...
Reflections & Referenc...
Java Applet Development
HotSpot Internals [ARC...
Java Advanced Imaging ...
Accessibility
Java Install / Autoupdate
Solaris on x86
Java Game Development
Java Enterprise System...
Sun Web Developer Pack...
Web Space Server
Oracle Communications ...
Sun ONE Meta-Directory
Java System Mobile Ent...
Oracle Net (SQL*Net、Ne...
初心者の部屋
On Track - General
Java (Japanese)
EPM System Infrastructure
Oracle University Deli...
Audit Vault and Databa...
システム管理
JD Edwards EnterpriseO...
WebCenter Portal JSK
Oracle Fusion Middlewa...
Code It
Eloqua Users with MS C...
Webcast Central
SFDC Integration
Eloqua Experience 2013
Pharma, Life Sciences,...
Oracle Compute Cloud S...
OTN América Latina Tou...
Industry Center of Exc...
Oracle Process Cloud S...
Eloqua - BlueKai Integ...
OMC - Industry Solutio...
Costa Rica
Move Goods
Enterprise Quality Man...
General Discussion
Danish Oracle User Gro...
TROUG Turkish Oracle U...
Oracle Linux Networking
OBIEE12C
Korea Engineered Syste...
OMC - Industry Solutio...
Accelerating Startups
IDGOUG - (Internationa...
Synopsis
Oracle Partner Acceler...
Oracle Marketing Cloud...
Brazil - Eloqua User G...
Modern Marketing Eloqu...
SQL and PL/SQL
Financials
Identity Manager
IA 64 Beta Program
Sensor-Based Services ...
Chinese
产品
개발자 (Korean)
PeopleSoft General Dis...
aqualogic.bpm.administ...
WebLogic开发
Swing
Oracle Business Intell...
Endeca Information Dis...
Oracle Java Cloud Service
Linux (Japanese)
Desktop
Test Partner Industry ...

Resources

Database Users
RDBMS discuss
Database Dev&Adm
javascript
java
csharp
php
android
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App