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: sybrandb <sybrandb_at_gmail.com>
Date: Tue, 10 Jul 2007 05:02:18 -0700
Message-ID: <1184068938.603908.180660@d55g2000hsg.googlegroups.com>


On Jul 10, 9:34 am, "alexander.stuckenh..._at_fernuni-hagen.de" <alexander.stuckenh..._at_gmail.com> wrote:
> 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?

Documentation anyone? Know where the Oracle reference manual is? Don't you learn how to use a manual at the Uni? Also: databases have tables and tables have *columns*, not *fields* For the rest: please RTFM

--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Jul 10 2007 - 07:02:18 CDT

Original text of this message

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