Re: Lots of tables in O7

You could actually do it with one table by having a special domain called DOMAIN or someting of the sort. The values within that domain would represent the different domains.

Ken Levine
Indepenndent Oracle Consultant
Vancouver, BC
>
>Oracle's CASE tool puts all lookup info into a single table when you design
>your database. This is a good indicator that a single table may be your
>best bet. (actually, two tables, one which lists the domains, and one
>for all the values contained under each domain.)
>
>- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> Sean_Stasica_at_stortek.com
>- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>
Received on Sat Jun 04 1994 - 09:57:34 CEST