Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> NUMBER datatype

NUMBER datatype

From: <gregk72_at_my-deja.com>
Date: Fri, 13 Aug 1999 01:56:08 GMT
Message-ID: <7ovtvl$2vq$1@nnrp1.deja.com> 





Q about the NUMBER datatype



If I do an ANALYZE TABLE on a table with NUMBER fields, it always
reports that NUMBER fields take 22 bytes regardless of the precision and
scale.  Do all NUMBER fields actually take 22 bytes, or is the size
variable by the precision and scale.



Thanks.






Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Thu Aug 12 1999 - 20:56:08 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US