Re: NULLS

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1997/03/08
Message-ID: <5fskdk$o9c@shadow.CSUFresno.EDU>#1/1

In article <331F0DFB.F8_at_saxe.com>, JP Soria <jpsoria_at_saxe.com> wrote:
>How much space does a null take?
>For example:
>I have a field, datatype varchar2(10), if this field is null for one
>row, how many bytes does it use?

It depends... Zero, if all additional columns at the end of the row are also null. Otherwise, one byte.

Steve Cosner
http://users.aol.com/stevec5088 Received on Sat Mar 08 1997 - 00:00:00 CST