RE: My 10 Commandments of Database Administration...

Dear God! Oracle Financials uses NULL in end_date on fnd_login to indicate either the current login or an abrupt termination of the user session neatly making your point and potentially providing with an enourmous number of cooks!

Allan

-----Original Message-----
=46rom: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nuno Pinto do Souto Sent: Wednesday, September 22, 2004 7:41 PM To: oracle-l_at_freelists.org
Subject: Re: My 10 Commandments of Database Administration...

Quoting from AUTHOR ryan gaffuri:
> 11. Thou shalt feed me if I have to work late to fix something you=20
> broke.
>
> I'm a single guy...

Nuno's design corollary #1:

Thou shall not use end_date =3D 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)...

--
http://www.freelists.org/webpage/oracle-l


___________________________________________________________________________=
___
This email is intended solely for the person or entity to which it is =
addressed and may contain confidential and/or privileged information.  =
Copying, forwarding or distributing this message by persons or entities =
other than the addressee is prohibited. If you have received this email in =
error, please contact the sender immediately and delete the material from =
any computer.  This email may have been monitored for policy compliance.  =
[021216]

--
http://www.freelists.org/webpage/oracle-l