viewing very long numbers

[pwo1433]

I have a table with a var that is number(18). When I view it via SQL Window, the var shows with scientific notation. I would much prefer to see the 18 digits, ie. without the decimal point and 'E'.
I figure there must be an option somewhere that I need to turn on/off but haven't found it.
My version of 6.0.5.931.

Anybody know how to do this?

Thanks.

 

[agent86]

to_char it =)

Only way I could find using the SQL window.

 

[Marco Kalter]

There is a SQL Window Preference for this: "Number fields to_char". If you enable it number fields will be returned as character strings, and will be formatted with full precision on the server.

 

[pwo1433]

Got it.
Thanks a lot!

 

[hbar]

Digging up an old thread here...to_char solves the problem, but it makes all my number fields go left-justified, which I hate. Oh how I hate it. Why does it not want to display numbers as unmolested numbers?

Interestingly, SQL*Plus shows large number results as scientific notation as well (as if SQL*Plus was the final say on display matters), but it only returns 6 sig figs. PL/SQL Developer returns 15 sig figs. Is this an NLS setting or something?

 

[vrbcik]

Well, to_char - option is not ok, because usually:
- I want to to_char only one column
- it's left justified
- when you sort it, it is sorted alphabetically, not mathematically :-/
Isn't there any other option?