DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Null value space ?

  1. 05-25-2005, 09:02 AM #1
    Multiple
    Multiple is offline Junior Member
    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 ,,,
    Reply With Quote Reply With Quote
  2. 05-25-2005, 04:57 PM #2
    John Spencer
    John Spencer is offline Junior Member
    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
    Reply With Quote Reply With Quote
  3. 05-25-2005, 05:22 PM #3
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width