And NEVER EVER name an object to a keyword. You wouldn't believe the hassle w/3rd party tools we have because of a table called "FUNCTION"...
Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Cary Millsap [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 30, 2002 5:54 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Table Naming Conventions > > > I just think it's a waste. You can tell by context what kind > of thing a > thing is. For example, consider: "select a.flarg from bloing a where > a.croopoo > 7". This can be understood by syntactical context > (even with > the nonsense names), without having to rename "bloing" to > "bloing_table". > > Most of the embedding of type names into object names that > I've seen has > been implemented by users who were inexperienced at the time they > created the standard. They were worried that without > embedding the type > name into the object name, they might forget what kind of > object it was. > ...Most such naming conventions become onerous over time, > long after you > find out that you can find the type of something in the data > dictionary, > but after it's too late to save the thousands of extra characters of > typing that'll waste people's lifespans over time. > > In my old OFA paper, I made a joke about how we don't embed type names > into object names in daily life, with just a few exceptions (Billy the > Kid, Winnie the Pooh, Atilla the Hun, and the younger family > members of > the old Walton Family TV show are a few examples). If you have both a > dog and a child named "Rex," though, it's probably a good > idea to expect > them both to come when you call. With SQL, though, I can't think of a > case in which it's not easy to tell by syntactic context what kind of > thing you're talking about... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
