Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i and null values
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 DBAReceived on Tue Jul 10 2007 - 07:02:18 CDT
![]() |
![]() |