Bill Inmon? Cool. Dan won't tell me more than "it's going to be incredible"
lots of my friends there, even if I do have to fly in at midnight the night before and fly out at midnight the night after :) --- Tim Gorman <[EMAIL PROTECTED]> wrote: > Yes! RMOUG Training Days is going to be an incredible event this > year! A > 2-day conference in Colorado during ski season with a lineup of > speakers > that rivals the major international conferences, including keynotes > by Bill > Inmon and Sue Cook! We're going to have a blast; I'm looking > forward to > meeting you! > > > on 11/3/03 2:59 AM, Tanel Poder at [EMAIL PROTECTED] wrote: > > > Hi! > > > >> Trailing columns with NULL values do not occupy any space, not > even a > > length > >> byte. > > > > Yep, I missed this one. Also, when few trailing null columns aren't > stored > > in a row, this particular rows column count is smaller as well, so > the > > column count in physical table storage can vary... > > > >> Non-trailing columns with NULL values have a constant value of > 0xFF (255) > > in > >> the length byte consuming just the one byte. > > > > Yep, and this means that even fixed-length CHAR datatypes don't > consume any > > space except length byte if they contain nulls. I once saw a > recommendation > > to store your data in char columns if you don't want to have to > worry about > > row size changes and PCTFREE setting... which is mostly a stupid > suggestion > > anyway and doesn't work in case of nulls either. > > > > Tanel. > > P.S. Tim, I assume that we'll meet at RMOUG training days this Feb? > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tim Gorman > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).