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 <tim_at_sagelogix.com> 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 tanel.poder.003_at_mail.ee 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: tim_at_sagelogix.com
>
> 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Mon Nov 03 2003 - 21:34:26 CST