| SQL Plus - Number formating [message #386033] |
Thu, 12 February 2009 05:06  |
galaxy
Messages: 62
Registered: October 2005
|
Member |
|
|
Hi,
I have a little "output" issue while using SQL Plus but I can't remember on the correct function/parameter to solve it.
I have a normal Select Query which includes as well a number field. But in the output of the query the values for that field are populated like '2.0000E+10' (So not the correct value is displayed).
Can somebody please let me know how I can display the numbers correctly (without the 'E')
Thanks in advance!
|
|
|
|
|
|
| Re: SQL Plus - Number formating [message #386070 is a reply to message #386033] |
Thu, 12 February 2009 08:09  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
SQL> create table tst (id number);
Table created.
SQL> insert into tst values (12345678901234567890);
1 row created.
SQL> select * from tst;
ID
----------
1.2346E+19
SQL> set numformat 99999999999999999999
SQL> /
ID
---------------------
12345678901234567890 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
