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: Null values insertion

Re: Null values insertion

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 22 Oct 1998 12:00:43 GMT
Message-ID: <362f1d08.19766053@news.siol.net>


On Thu, 22 Oct 1998 11:37:36 +0200, "Itai Gan" <itaig_at_ncc.co.il> wrote:

>does anyone know if inserting null numbers into a table create the space in
>the disk or not???

If the column containing NULLs is the last column in a table definition then no disk space is occupied with those null values. If the column is not the last one then 1 byte per null is occupied.

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Oct 22 1998 - 07:00:43 CDT

Original text of this message

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