Null value space ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Null value space ?

  1. #1
    Join Date
    May 2005
    Posts
    3

    Null value space ?

    Hi to all members .

    My questuion about the space that reserved by null value in Oracle 10g ?


    Thanks ,,,

  2. #2
    Join Date
    May 2005
    Location
    Toronto Canada
    Posts
    57
    It depends on where the NULL column is in the set of columns for the table. If the NULL column is in the middle of the table and is followed by other non-NULL columns, then it takes one byte of storage (the length indicator). If it is the last column of the table, or if all following columns are null, then it (and any following columns) takes zero bytes.

    John

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,971
    You really are persistant. I already pointed you to the documentation.

    Duplicate post

    Originally posted by gandolf989
    There is this wonderful tool called tahiti.oracle.com. It contains all of the documentation that you should need. In fact I was able to find out about nulls is about 30 seconds. You should avail yourself of all of the resources out there.

    And quit starting second threads like "I'm waiting." As people volunteer their time, there should be no expectation of urgency on getting any kind of response.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width