Home » SQL & PL/SQL » Client Tools » SQL Plus - Number formating (9.2.0.8.0)
SQL Plus - Number formating [message #386033] Thu, 12 February 2009 05:06 Go to next message
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 #386038 is a reply to message #386033] Thu, 12 February 2009 05:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the type of the field?
What is the actual value in database?
Post a Test case: create table and insert statements along with the result you want with these data.

Regards
Michel
Re: SQL Plus - Number formating [message #386070 is a reply to message #386033] Thu, 12 February 2009 08:09 Go to previous message
Frank
Messages: 7880
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
Previous Topic: Hammer Ora
Next Topic: Cannot login as sysdba using isqlplus
Goto Forum:
  


Current Time: Thu Dec 08 06:01:09 CST 2016

Total time taken to generate the page: 1.08700 seconds