Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Single Code Table or Separate Code tables dilemma

Re: Single Code Table or Separate Code tables dilemma

From: Michael Netrusov <>
Date: Fri, 23 Mar 2001 11:16:29 -0800
Message-ID: <>

> at last i convinced my duhvelopers to go for individual tables.

Probably they were just unaware of how much code they would have to write. DUHelopers are easy to convince - they just have no brain. Developers have. :-))

> > -----Original Message-----
> > From: Steve Orr []
> > Sent: Thursday, March 22, 2001 5:55 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Single Code Table or Separate Code tables dilemma
> >
> >
> > Regarding "lookup" or validation tables and more complex
> > "rules" tables...
> > do they ALL go into your master code table? For instance,
> > what about a "code
> > table" for all valid U.S. zip codes? Do they go into your
> > master code table?
> we r in the process for defining country--->state/province--->city and
> airports tables. there would be another 30-40 masters and all in different
> tables :-) sweet smell of victory

:-) In this case you have dependencies. I would create multiple tables there.

> > State abbreviations too? What about valid city/state/zip code
> > combinations
> > which you can get from the U.S.P.O.? At what point are
> > validation/lookup/rules data not in the master code table and
> > how do you
> > decide?
> i blive every logical entity should hv its seperate physical presence.

I think if logical entities differ from each other only a couple of attributes, they should go into one table.

> but then every solution is an "Engineering Compromise". So i wont mind some
> give and take. but its fun to have an occasional fight with a duhveloper.

Yeah, a duhveloper might consider it's fun to write 10 packages which differ only by name and a couple attributes.
Later he might claim that he wrote 10K lines of code ( instead of 1K ) and worked hard. :-)

Michael Netrusov

Please see the official ORACLE-L FAQ:
Author: Michael Netrusov

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 Fri Mar 23 2001 - 13:16:29 CST

Original text of this message