Home » SQL & PL/SQL » Client Tools » SQL Plus - Number formating (
SQL Plus - Number formating [message #386033] Thu, 12 February 2009 05:06 Go to next message
Messages: 62
Registered: October 2005

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: 67769
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.

Re: SQL Plus - Number formating [message #386070 is a reply to message #386033] Thu, 12 February 2009 08:09 Go to previous message
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;


SQL> set numformat 99999999999999999999
SQL> /

Previous Topic: Hammer Ora
Next Topic: Cannot login as sysdba using isqlplus
Goto Forum:

Current Time: Mon Mar 08 03:46:16 CST 2021