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: minimum space taken by null varchar2 ?

Re: minimum space taken by null varchar2 ?

From: Erwin Dondorp <erwindon_at_wxs.nl>
Date: 2000/06/21
Message-ID: <3951060D.703F700E@wxs.nl>#1/1

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 Wed Jun 21 2000 - 00:00:00 CDT

Original text of this message

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