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

Home -> Community -> Usenet -> c.d.o.server -> How many byte NUMER(19) take?

How many byte NUMER(19) take?

From: <dominica_at_secondhat.com>
Date: 2000/08/03
Message-ID: <8mcl1c$npa$1@secondhat.secondhat.com>#1/1

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

Original text of this message

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