Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: minimum space taken by null varchar2 ?
I'm not sure if this is still true in Oracle 8, but "used to be" that if
null allowed columns were
followed by not null columns, then Oracle reserved max space in the column
definition
for the nullable columns to avoid fragmentation during updates.
Greg
Erwin Dondorp <erwindon_at_wxs.nl> wrote in message
news:3951060D.703F700E_at_wxs.nl...
> Ian Wood wrote:
> > What is the minimum amount of space taken by a varchar2 null column?
>
> Null values take up 1 byte, independent of their datatype.
> Null values in the last columns of a record take up 0 bytes.
>
> Should be written at least in the "Concepts" manual.
>
> Erwin
Received on Fri Jun 23 2000 - 00:00:00 CDT