OraFAQ Forum: Client Tools » Number Data Type Column does not display number as it was entered

Home » Other » Client Tools » Number Data Type Column does not display number as it was entered (ORACLE 8i and Form 6i)

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

Number Data Type Column does not display number as it was entered [message #462819]

Mon, 28 June 2010 00:36

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

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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