Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: My 10 Commandments of Database Administration...
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-lReceived on Thu Sep 23 2004 - 03:47:44 CDT
![]() |
![]() |