Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Developer 24.3 NUMBER columns not being displayed correctly in grid (ISSUE RESOLVED)

Jacques R. KilchoerNov 26 2024 — edited 41 hours ago

I am seeing the same isue as mentioned in this post
https://forums.oracle.com/ords/apexds/post/sql-developer-24-3-random-values-in-result-grid-for-number-0015

I unzipped the Windows 64-bit version in a separate folder and am running sqldeveloper.exe from that folder
Windows 64-bit with JDK 17 included sqldeveloper-24.3.0.284.2209-x64.zip

SQL Developer Version 24.3.0.284 build 284.2209
Oracle IDE 24.3.0.284.2209
Plate-forme Java(TM) 17.0.13
Prise en charge de la gestion des versions 24.3.0.284.2209

Windows:
Édition Windows 11 Professionnel Version 23H2
Installé le ‎19.‎03.‎2023 (for the Americans that would mean 2023-03-19)
Build du système d’exploitation 22631.4460
Expérience Windows Feature Experience Pack 1000.22700.1047.0

In my connection properties, for the instance I am connecting to, under Advanced, Use OCI is NOT checked
I guess that means I am using a thin JDBC connection?

Oracle database version
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.25.0.0.0

If I run, for example, this query in SQLDeveloper

select owner, object_name, object_type, object_id from all_objects where owner = 'SYS' and object_name = 'ALL_TABLES' and object_type = 'VIEW' ;

I see this in the grid output
SYS ALL_TABLES VIEW oracle.sql.NUMBER@7fde7843

This post has been answered by thatJeffSmith-Oracle on Nov 27 2024
Jump to Answer
Comments
Post Details
Added on Nov 26 2024
10 comments
170 views