Number datatype does not waste space if the column data type is larger than
the stored number.
Take a look at
http://www.vampired.net/forums/viewtopic.php?topic=24&forum=15&0 to see how
number data types are stored.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
[mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 25, 2001 7:20 AM
To: Multiple recipients of list ORACLE-L
Hi lists
what is the precision of the number datatype, if not in a table.
is it 1 or 32.
(in v$sgastat the column bytes doesn't have precision,scale mentioned. this
column values should be stored in our routine tables.)
If I take the maximum ,I may be wasting the space.
can anybody advise how much precision do I take?
and is there any way to find from what x$ tables this is (v$sgastat) built .
I didnt find it is dependencies table.
thnx in advance
srinivas.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
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: [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: Christopher Spence
INET: [EMAIL PROTECTED]
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: [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).
