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 -> Minimum bytes of storage for each data type

Minimum bytes of storage for each data type

From: <sriviswa_at_hotmail.com>
Date: Wed, 24 Nov 1999 18:46:00 GMT
Message-ID: <81hbp7$6q7$1@nnrp1.deja.com>


Hi,

Is there a minimum bytes of storage that oracle would use for each data type irrespective of the data within. For example, I have a NUMBER(3) column. The DATA_LENGTH and DATA_PRECISION in the USER_TAB_COLUMNS show 22 and 3 respectively. Which one should I use for calculating row lengths. Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 12:46:00 CST

Original text of this message

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