Re: My 10 Commandments of Database Administration...

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: nsouto@xxxxxxxxxxxxxx
  • Date: Thu, 23 Sep 2004 09:52:09 +0100

On Thu, 23 Sep 2004 10:40:48 +1000 (EST), Nuno Pinto do Souto
<nsouto@xxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l

Other related posts: