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: Norrell, Brian <>
Date: Thu, 22 Mar 2001 16:16:20 -0800
Message-ID: <>

Preface: I am a developer!

If the DBA wants to have 10000 tables, no skin off my nose. A generic maintenance form and LOV form for a set of tables all with the same format is not that huge a task.

The best developer argument AGAINST a centralized code table is that eventually someone will request an enhancement that adds functionality to one of the codes beyond a simple code/description table. This means the codes have to be pulled out of the central code table and created as a new table with the 3 flags and 5 coded fields to support the new functionality. The DBA work on that is easy, but then the developers go hunting in all the existing program code that hits the code table (haystack) to find all the places where that program code is actually using the code in question

If I were starting a product from scratch and there was a central code table I would probably code against a set of views in anticipation of the above event, so the DBA ends up creating 10000 objects anyway.

On the other hand:
1. Everywhere I have worked, there has been a central code table of some sort.
2. In all cases that code table was put in place by the DBAs, not the developers, because they didn't want all those tables and were not really hung up on referential integrity that the application was enforcing anyway.

Brian Norrell
Manager, MPI Development
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600

Please see the official ORACLE-L FAQ:
Author: Norrell, Brian

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 Thu Mar 22 2001 - 18:16:20 CST

Original text of this message