| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> number column precision
FYI,
And some of you must have laughed or shaken your heads when reading my =
post,
but even if you have a column specified as NUMBER or NUMBER (x,0), you =
can
still get decimal values out of it.
Oracle stores numbers in scientific format, e.g. 400 is stored as 2 x = 10^2.
400.1 is stored as 4.001 x 10^2, and so on.
The mantissa can have up to 38 digits.
I sent an e-mail to the head developer and the end users who were =
panicking,
I think the problem has more to do with how sqlplus is configured on =
their
machines. (there are two parameters: NUMFORMAT and COL xxx FORMAT
9999.99999. the COL example I give here does return decimals from a
NUMBER(9,0) column.
I read in the Oracle7 Concepts manual that Oracle5 used to be able to =
store
plus infinity and minus infinity. I wonder why they dropped this in =
Oracle6
and beyond. ( to infinity and beyond! Sorry I have a 4 year old).
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst=E8mes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique=20 Maritimes Region, DFO | R=E9gion des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20
-----Original Message----- From: Shevtsov, Eduard [SMTP:EShevtsov_at_flagship.ru] Sent: Thursday, August 31, 2000 4:02 AM To: Multiple recipients of list ORACLE-L Subject: RE: alter system set user_dump_dest problem How is that? It's puzzle for me... Ed > =20 > =20Received on Thu Aug 31 2000 - 05:43:06 CDT
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
> With the Partitioning and Java options
> PL/SQL Release 8.1.5.0.0 - Production
> =20
> SQL> select name, issys_modifiable from v$parameter where name
like
> '%dump%';
> =20
> NAME =20
> ISSYS_MOD
> -------------------------------------------------------------
> --- ---------
> shadow_core_dump =20
> FALSE
> background_core_dump =20
> FALSE
> background_dump_dest =20
> IMMEDIATE
> user_dump_dest =20
> IMMEDIATE
> max_dump_file_size =20
> IMMEDIATE
> core_dump_dest =20
> IMMEDIATE
> =20
> SQL> alter system set user_dump_dest=3D'C:\temp';
> =20
> System altered.
> =20
> -----Original Message-----
> Eduard
> Sent: Wednesday, August 30, 2000 1:18 PM
> To: Multiple recipients of list ORACLE-L
> =20 > =20
> Hi Sean and List
> =20
> SQL> select * from v$version;
> =20
> BANNER
> -------------------------------------------------------------
> Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
> PL/SQL Release 8.1.5.0.0 - Production
> CORE Version 8.1.5.0.0 - Production
> TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
> NLSRTL Version 3.4.0.0.0 - Production
> =20
> SQL> col name format a20
> SQL> select name, issys_modifiable
> 2 from v$parameter
> 3 where name like 'user_dump%';
> =20
> NAME ISSYS_MOD
> -------------------- ---------
> user_dump_dest FALSE
> =20 > =20
> I don't think that behavior of the user_dump_dest was changed.
> Can anyone check this?
> =20
> Ed
> =20 > =20
> > SQL>alter system set user_dump_dest =3D 'e:\oradba\admin\tst';
> > *
> > ERROR at line 1:
> > ORA-02095: specified initialization parameter cannot be
modified
> >
> > This is Oracle 8.0.5 on NT4-SP4. According to
> > Oracle8 Reference
> > Release 8.0
> > A58242-01
> > ALTER SYSTEM SET can be used to change this initilization=20
> parameter.
> > Pulling my hair (what's left of it that is) out on this=20
> one. Bethca' it's
> > something simple. What am I doing wrong??? Aaaarrggggghhhhh.
> >
> >
> > Sean :)
> >
> > ###### ###### ###### ######
> > # # # # # # # # Rookie
> > #### # # ###### ###### Data
> > # # # # # # # # Base
> > # # ####### ###### # # Adminstrator
> > -------------------------------- ------------
> > Organon (Ireland) Ltd.
> > E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]
> >
> > The only man who never makes a mistake is the man who=20
> never does anything.
> > - Theodore Roosevelt
> >
> >
> >
> >
> >
> >
> >
> > --
> > Author: O'Neill, Sean
> > INET: Sean.ONeill_at_organon.ie
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> > San Diego, California -- Public Internet access /=20
> Mailing Lists
> >=20
> --------------------------------------------------------------------
> > 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=20
> subscribing).
> >
> =20
> --
> Author: Shevtsov Eduard
> INET: eshevtsov_at_flagship.ru
> =20
> Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> San Diego, California -- Public Internet access /=20
> Mailing Lists
> --------------------------------------------------------------------
> 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). > =20
> --=20
> Author: Linda Wang
> INET: lwang_at_messagemedia.com
> =20
> Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> San Diego, California -- Public Internet access /=20
> Mailing Lists
> --------------------------------------------------------------------
> 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). > =20 --=20 Author: Shevtsov, Eduard INET: EShevtsov_at_flagship.ru Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
 |
 |