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 -> Re: Oracle 9i and null values

Re: Oracle 9i and null values

From: <alexander.stuckenholz_at_fernuni-hagen.de>
Date: Tue, 10 Jul 2007 00:34:41 -0700
Message-ID: <1184052881.932893.248530@22g2000hsm.googlegroups.com>


On 9 Jul., 19:05, pound..._at_nyc.rr.com wrote:
> For a VARCHAR2, the length field is variable depending on the size of
> the data. If the length is <= 250, then the length field is one byte.
> For strings > 250 the first byte is 0xFE followed by a two byte length
> field. Nulls are represented by a single byte of 0xFF.
>
> JR

Ok. I know now for varchar2. But how much bytes are uses by a NULL value in a number(p, s) or other fields? Received on Tue Jul 10 2007 - 02:34:41 CDT

Original text of this message

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