Re: NULLS

From: L120bj <l120bj_at_aol.com>
Date: 1997/03/07
Message-ID: <19970307184501.NAA23941@ladder01.news.aol.com>#1/1

It depends. If the column is in the middle of a row, then it will take up 1 byte. However any null fields at the end of a row take up no space, since part of the ORACLE row configuration is a count of the number of columns that make up the row. So if a row had 7 columns but the last 2 were null, ORACLE would store this as just 5 columns.

---

---

Subject: NULLS
From: JP Soria <jpsoria_at_saxe.com>
Date: Thu, 06 Mar 1997 11:33:31 -0700
Message-ID: <331F0DFB.F8_at_saxe.com>

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?

-- 
JP Soria
Jr. Oracle7 DBA
Email: jpsoria_at_saxe.com
"Failing to plan = planning to fail"

Received on Fri Mar 07 1997 - 00:00:00 CST