OraFAQ Forum: Client Tools » Oracle number format

Home » SQL & PL/SQL » Client Tools » Oracle number format (Any)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle number format [message #652120]

Thu, 02 June 2016 04:10

pkapoor
Messages: 2
Registered: June 2016
Location: india

Junior Member

Hello,

I have a table with below details:
SQL> select * from TM_xxx;

COL2 TEST_ROW_ID
---------- -----------
9.4436E+14 1
1.6578E+24 2

Table description:
SQL> describe TM_xxx
Name Null? Type
----------------------------------------- -------- --------------------------

COL2 NUMBER(38)

How can i get data in column2 displayed as simple integer values and not exponential format

Report message to a moderator

Re: Oracle number format [message #652121 is a reply to message #652120]

Thu, 02 June 2016 04:19

Littlefoot
Messages: 21578
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There are a few options I can think of, such as

SQL> create table test (col number(38));

Table created.

SQL> insert into test values (56465464654654654654);

1 row created.

SQL> select * From test;

       COL
----------
5,6465E+19

SQL> column col format 999999999999999999999999999999999
SQL> select * From test;

                               COL
----------------------------------
              56465464654654654654

SQL> set numformat 9999999999999999999999999
SQL> select * From test;

                       COL
--------------------------
      56465464654654654654

SQL> set numwidth 25
SQL> select * From test;

                      COL
-------------------------
     56465464654654654654

Report message to a moderator

Re: Oracle number format [message #652122 is a reply to message #652121]

Thu, 02 June 2016 04:27

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

Note this is all sqlplus specific

Report message to a moderator

Re: Oracle number format [message #652123 is a reply to message #652120]

Thu, 02 June 2016 04:34

Littlefoot
Messages: 21578
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This:

pkapoor

SQL> select * from TM_xxx;

suggests that OP is using SQL*Plus /forum/fa/3314/0/

Report message to a moderator

Re: Oracle number format [message #652127 is a reply to message #652123]

Thu, 02 June 2016 05:10

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

I should have been clearer. I'm sure the OP is using sqlplus here. I just wanted to make sure he (and anyone else reading this) realised that the problem was solely due to sqlplus settings rather than anything to do with DB and could only be fixed by adjusting those settings. You already knew that.

Report message to a moderator

Re: Oracle number format [message #652160 is a reply to message #652127]

Thu, 02 June 2016 23:32

pkapoor
Messages: 2
Registered: June 2016
Location: india

Junior Member

Thank you all for the reply.

Report message to a moderator

Previous Topic:	TNSNAMES not detected
Next Topic:	Installing example Schemas v2...Help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 04 12:38:21 CDT 2020