Re: Are trailing null columns stored?

wvw_at_moose.uvm.edu (Warren Van Wyck) writes:

>V6 System Architecture training Doc (page 1-40) states:
> "Trailing null fields not stored"
>
>I tried a test. I inserted a row with both an embedded null column (field)
>and some trailing null fields. After a commit and checkpoint, I dumped the
>relevant Oracle block. It appears that both the embedded null field and
>the trailing ones use one byte of disk storage each -- it's value is x'ff'.
>
>This is of limited practical significance (since we don't have many rows
>with trailing null fields), but I am curious what the facts really are.
>Does anyone have a definitive answer?
>
>We are running Oracle 6.0.34.3.1 (TPO) under AIX 3.2.
>
>Warren Van Wyck University of Vermont wvw_at_moose.uvm.edu (802)656-8421
>--
> Warren Van Wyck Analyst/Programmer (802)656-8421
> University of Vermont, Computing and Information Technology
> Internet: wvw_at_moose.uvm.edu
 

My understanding is that as long as there are no embedded null columns, then the manual is correct.

Bernie Shiao
shiao_at_stsci.edu Received on Sat Jun 05 1993 - 00:22:59 CEST