Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: My 10 Commandments of Database Administration...

Re: My 10 Commandments of Database Administration...

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 23 Sep 2004 09:52:09 +0100
Message-ID: <7765c897040923015227d29be5@mail.gmail.com>


On Thu, 23 Sep 2004 10:40:48 +1000 (EST), Nuno Pinto do Souto <nsouto_at_bizmail.com.au> wrote:
> Quoting from AUTHOR ryan gaffuri:
> > 11. Thou shalt feed me if I have to work late to fix something you
> > broke.
> >
> > I'm a single guy...
>
>
> Nuno's design corollary #1:
>
> Thou shall not use end_date = NULL to mean "current row" of ANYTHING!
> NULL has NO MEANING whatsoever: it does NOT mean "current"!

true. But that doesn't mean you can use December 31st 2099 to mean no end date recorded either...

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 23 2004 - 03:47:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US