Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How many byte NUMER(19) take?
Hi Everyone,
Do you know how to calculate
what is the size of the following record?
For example, number(19) is how many byte???
I know there is a VSIZE command in sqlplus. But I would like to calculate if the whole record is FULLY used.
Like field_10 is VARCHAR2(1024), I will assume is actually filled with 1024 character.
Thank you in advance,
Please email me directly to dominica_l_at_yahoo.com
after underline is a lowercase L, not a ONE.
Dominica Leung
a table
FIELD_1 NOT NULL NUMBER(19) FIELD_2 NOT NULL NUMBER(19) FIELD_3 NOT NULL DATE FIELD_4 DATE FIELD_5 DATE FIELD_6 DATE FIELD_7 DATE FIELD_8 NUMBER(19) FIELD_9 NUNBER(2) FIELD_10 VARCHAR2(1024)Received on Thu Aug 03 2000 - 00:00:00 CDT