Re: My 10 Commandments of Database Administration...

  • From: "Nuno Pinto do Souto" <nsouto@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 23 Sep 2004 10:40:48 +1000 (EST)

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"!

Under penalty of having to cook for Nuno (and I'm a heavy bloke)...


Other related posts: