Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Table Naming Conventions

RE: Table Naming Conventions

From: Jesse, Rich <>
Date: Wed, 31 Jul 2002 06:53:36 -0800
Message-ID: <>

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              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Cary Millsap []
> 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:
Author: Jesse, Rich

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: (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).
Received on Wed Jul 31 2002 - 09:53:36 CDT

Original text of this message