Mark Huebner <mkhuebner_at_sprynet.com> wrote in message
news:37b8c893.7039602_at_news.sprynet.com...
> Could somebody tell me what the size of Oracle 7/8 data types is? Is
> this information in any book? Is a NUMBER data type always 16 bytes
> long? Does Oracle store numbers in less space (less than 16 bytes) if
> the precision is specified (e.g., NUMBER(5,2))? Does a NUMBER(5,2)
> take less space than a NUMBER(8,3)? How big is a SMALLINT, a DATE,
> etc? Are there any performance considerations?
- You can refer the "Oracle concepts" manual.
- You can use DUMP() or VSIZE() function to find out how many bytes they occupied.
Received on Wed Aug 18 1999 - 06:38:26 CDT
