Re: Storing of number datatype in table

Try this before your select:

set numwidth 38

Then is should work. The reason is that sqlplus has a default length value for showing number fields. Before setting it to something else, try and type:

show numwidth

that should tell you the default.

Thanks,
KidRac

Sathyanaryanan_K/VGIL_at_vguard.satyam.net.in wrote:

>Dear List
>
>Have a look at the sql !!!
>
>SQL> create table trnid
> 2 ( trn_id number(10));
>Table created.
>
>SQL> insert into trnid(trn_id) values('1111111111');/* 10 1's inserted*/
>1 row created.
>
>SQL> insert into trnid(trn_id) values('111111111');/* 9 1's inserted*/
>1 row created.
>
>SQL> commit;
>Commit complete.
>
>SQL> select trn_id from trnid;
>
> TRN_ID
>---------
>1.111E+09
>111111111
>
>can anyone tell why the number(10) is stored in exp format
>
>Regards,
>
>Sathyanarayanan
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Morten Egan
  INET: meg_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).