Home » SQL & PL/SQL » Client Tools » Number Data Type Column does not display number as it was entered (ORACLE 8i and Form 6i)
Number Data Type Column does not display number as it was entered [message #462819] Mon, 28 June 2010 00:36 Go to next message
mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan
Senior Member
Dear fellows,

All of you have always helped me in my crusial times. I really very thankfull.

Now i have a problem which i am facing for the first time. The problem is:

I have created a table test1 with two column of number data type and the column witdth is 25. Then enter the data but when i select the recrod it does not display the column data as it was entered.
SQL> create table test1
  2  (
  3  startno number(25),
  4  endno number(25)
  5  );

Table created.

SQL> insert into test1
  2  values(8992020404050503030900,8992020404050503031000);

1 row created.

SQL> select * from test1;

  STARTNO     ENDNO
--------- ---------
8.992E+21 8.992E+21

SQL> 


I have also searched the forum but not found the solution.

Would any body please help me in this regard?

Muhammad Khalil

[Updated on: Mon, 28 June 2010 00:39]

Report message to a moderator

Re: Number Data Type Column does not display number as it was entered [message #462820 is a reply to message #462819] Mon, 28 June 2010 00:56 Go to previous messageGo to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
Search for Number format models.


Regards
Ved

[Updated on: Mon, 28 June 2010 01:57]

Report message to a moderator

Re: Number Data Type Column does not display number as it was entered [message #462835 is a reply to message #462819] Mon, 28 June 2010 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 58597
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set numwidth:
SQL> select 8992020404050503030900,8992020404050503031000 from dual;
8992020404050503030900 8992020404050503031000
---------------------- ----------------------
            8.9920E+21             8.9920E+21

1 row selected.

SQL> set numwidth 30
SQL> /
        8992020404050503030900         8992020404050503031000
------------------------------ ------------------------------
        8992020404050503030900         8992020404050503031000

1 row selected.

Regards
Michel
Re: Number Data Type Column does not display number as it was entered [message #462840 is a reply to message #462820] Mon, 28 June 2010 02:20 Go to previous messageGo to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
Which tool you are using?

If you are using Toad, turn off the Scientific Notation in Toad.

View->Toad Options->Data Grids->Data

uncheck the "Display large numbers in Scientific Notation" option


Using Format model
SQL> select 123456789012 from dual;

123456789012                                                                                        
------------                                                                                        
  1.2346E+11                                                                                        

SQL> select to_char(123456789012,999999999999 ) from dual;

TO_CHAR(12345                                                                                       
-------------                                                                                       
 123456789012                                                                                       



Ved



[Updated on: Mon, 28 June 2010 02:24]

Report message to a moderator

Re: Number Data Type Column does not display number as it was entered [message #462841 is a reply to message #462819] Mon, 28 June 2010 02:28 Go to previous messageGo to next message
mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan
Senior Member
Thanks a lot. My problem has been solved with above set statement.
Re: Number Data Type Column does not display number as it was entered [message #585652 is a reply to message #462840] Tue, 28 May 2013 12:10 Go to previous message
saket140
Messages: 1
Registered: May 2013
Junior Member
Good one Ved
Previous Topic: urgent reqirement
Next Topic: PLS-00201: identifier 'Q$ERROR_MANAGER.REGISTER_ERROR' must be
Goto Forum:
  


Current Time: Mon Jul 28 00:41:37 CDT 2014

Total time taken to generate the page: 0.07611 seconds