Are null CHAR() columns compressed in any way?

[BobWhitefield]

In Oracle 8 or later, if I declare a column as CHAR(20), and have 100K rows where this column is null, is this actually using two megs of storage, or does Oracle employ some kind of compression mechanism?

Thanks!
Bob

 

[sem]

Oracle doesn't use space for empty values. Though, it uses some fixed amount of space for record/field markers.

 

[BobWhitefield]

Just as I hoped. Thanks sem!