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!

Is there a way to set default format for numbers the SQL Developer query results?

Hi there

Is there a way in SQL Developer's setting or preference where I can set the default format masking for numbers in the query result so that I don't have to wrap the numbers with TO_CHAR to format the numbers every time I query something.

All I want is a comma for every three digits and round to two decimal places. I wonder if there is a setting for this?

This post has been answered by mathguy on Apr 28 2024
Jump to Answer
Comments
Post Details
Added on Apr 26 2024
1 comment
1,245 views