Re: Max number of Tables ?
Date: Thu, 16 Mar 1995 05:04:37 GMT
Message-ID: <D5Iorq.I9D_at_eskimo.com>
I don't really like this "solution" but it may be better than having hundreds of tables: can you just define every fields as VARCHAR2 and rely on the application to perform checkings. Of course, you may need a "code" field to identify which message has what format or which message is for what. That way you can have a very flexible table. Be warned: do not go overboard with this. Use this method only when the alternatives are worse. If you are using version 7, you may want to use database triggers to enforce the "rules".
By the way (I am not saying that I like the above method), ORACLE uses the above method for one of the tables in ORACLE FINANCIALS.
Have fun,
Kim
Stan Novinsky (stan_novinsky_at_jhuapl.edu) wrote:
: surman_at_oracle.com (Scott Urman) wrote:
: >
: >
: > You don't want each message to be a separate table, you want each message to
: > be a separate row in the same table.
:
: This sounds good, but can each message be a separate row if each
: message is composed of variable fields:
: ex: Message 1 is made up of the following
: Field 1 is INTEGER
: Field 2 is CHARACTERS
: Field 3 is REAL
: Field 4 is CHARCATERS
: Message 2 is made up of the following
: Field 1 is CHARACTERS
: Field 2 is CHARACTERS
: Field 3 is REAL
: Field 4 is INTEGER
: Field 5 is INTEGER(80)
Received on Thu Mar 16 1995 - 06:04:37 CET