Skip to Main Content

SQL Developer for VS Code

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!

Datatype NUMBER query result - SQL Notebook vs SQL Worksheet

Bernd MainzAug 21 2025

Data of type "NUMBER" is displayed differently in the query result grid on SQL Notebooks than on SQL Worksheets:

desc all_users

/*
Name Null? Type 
----------------- -------- ------------------ 
USERNAME NOT NULL VARCHAR2(128 BYTE) 
USER_ID NOT NULL NUMBER 
CREATED NOT NULL DATE 
...
*/

select user_id from all_users where username = 'SYSBACKUP';

→ SQL Notebook “2,147,483,617”

→ SQL Worksheet “2147483617”

(Version 25.2.2)

This post has been answered by thatJeffSmith-Oracle on Aug 21 2025
Jump to Answer
Comments
Post Details
Added on Aug 21 2025
1 comment
43 views