set numwidth value in login.sql file oracle read it when open a new session
Satyendra .. [EMAIL PROTECTED] wrote: > Thank u list for ur imm resp. It was the prob with numwidth. > Now I have set the num width to 25 and s working fine. > But whenever i stat the sql the default is set to 9. how do i change the > def numwidth?? > Regards, > > Sathyanarayanan > > |--------+-----------------------> > | | "Arup Nanda" | > | | <arupnanda@ho| > | | tmail.com> | > | | | > | | 22/11/2002 | > | | 19:38 | > | | Please | > | | respond to | > | | ORACLE-L | > | | | > |--------+-----------------------> > >------------------------------------------------------| > | | > | To: Multiple recipients of list ORACLE-L | > | <[EMAIL PROTECTED]> | > | cc: (bcc: Sathyanaryanan K/VGIL) | > | Subject: Re: Storing of number datatype in | > | table | > >------------------------------------------------------| > > The number is more than the numwidth specified. Try this > > SQL> set numwidth 13 > SQL> select trn_id from trnid; > > Your numwidth is perhpas defined as 9; so anything of more precision is > displayed as exponetial notation; internally all numbers are stored the > same. > > HTH > > Arup Nanda > www.proligence.com > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, November 22, 2002 6:23 AM > > > 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: > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Arup Nanda > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Satyendra K Khare INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).