From oracle-l-bounce@freelists.org Thu Sep 23 07:37:42 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8NCbf111220 for ; Thu, 23 Sep 2004 07:37:41 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i8NCbfI11202 for ; Thu, 23 Sep 2004 07:37:41 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5AD7872D82C; Thu, 23 Sep 2004 07:43:42 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32733-86; Thu, 23 Sep 2004 07:43:42 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F232B72D750; Thu, 23 Sep 2004 07:43:40 -0500 (EST) X-Server-Uuid: 46006885-B867-4476-8FA3-B9628A74E682 X-MimeOLE: Produced By Microsoft Exchange V6.0.6556.0 content-class: urn:content-classes:message MIME-Version: 1.0 Subject: RE: My 10 Commandments of Database Administration... Date: Thu, 23 Sep 2004 07:41:36 -0500 Message-ID: <7E0DB3A126BA9146AC30744E2B7E42459744D9@midhouhqxch01.net.smith.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: My 10 Commandments of Database Administration... Thread-Index: AcShHLcgMpPuCLIkTPOQGczv+ZOHewATX9QQ From: "Nelson, Allan" To: oracle-l@freelists.org X-OriginalArrivalTime: 23 Sep 2004 12:41:47.0140 (UTC) FILETIME=[B0679440:01C4A16A] X-WSS-ID: 6D4C1B0B1Y4554246-01-01 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 9965 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: anelson@miswaco.com Precedence: normal Reply-To: anelson@miswaco.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Nuno Pinto do Souto Sent: Wednesday, September 22, 2004 7:41 PM To: oracle-l@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