Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: minimum space taken by null varchar2 ?
Ian Wood wrote:
>
> Hi All,
>
> What is the minimum amount of space taken by a varchar2 null column?
>
> I cannot seem to find this.
>
> Thanks,
>
> Ian
(In a table) zero bytes if no non-null data follows it in the row.
Otherwise 1 byte
HTH
-- =========================================== Connor McDonald http://www.oracledba.co.uk We are born naked, wet and hungry...then things get worseReceived on Wed Jun 21 2000 - 00:00:00 CDT