Remove the delimeter between groups of digits in the result window

M

Mr. Doughx

Member
Guys, I wonder if someone can help me.

All numbers in my result window (grid) are shown with а delimeter symbol after every 3 digits.

I can chose a delimeter symbol via Preferences/NLS Options/Numbers/Decimal Group symbol, but I can't remove it

In general Oracle SQL Developer all numbers are shown without any delimeters
What's the matter?
How to solve it?
 
What OS are you using? I'm using Windows 10. For the location you mention, my preferences are set to "Windows format" (the default). This means I cannot change either the Decimal Symbol or Digit Group Symbol. All integers that get selected from the DB show up as a string of digits with no group symbol in them, i.e. 12345678
 
You can go to Preferences > SQL Window and disable the "Formatted with thousand separator" option in the "Number Layout" section.
 
I'm using Win10 also.
If I choose "Windows format" I can influence the decimal point symbol or the symbol of the digit group separator, but I can't turn the division itself on or of
 
Marco, thank you! Your answer solved my problem perfectly!
This is exactly what I was asking about!
Thank you again for your prompt professional help!
 
You must log in or register to reply here.
Back
Top