Re: Looking for a way to implement SQL-92 Domain

Hi John,

If I understand you correctly, you want to put the contents of the lookup tables in one table. If you include domain, code, lookup-value, then why would you still need the seperate lookup tables? I'd suggest, use only this single domain table and keep it up to date, and get rid of all the small tables.

regards,

Henk Hultink

--
H. Hultink
Software Engineer
Stoas, Division OBOI
Wageningen, The Netherlands
"Activating Knowledge"
http://www.stoas.nl

e-mail: hhu_at_stopspam.stoas.nl

"John Bossert" <jbossert_at_usa.net> wrote in message
news:3E7E68EF.2040604_at_usa.net...


> I have a slew of tiny look-up tables (2-5 rows) that I'd like to

consolidate


> into a single table {domain, code, look-up-value}, and then have a CHECK

> constraint that does a select against a view that filters the particular

domain


> value.

>

> Then it's pointed out to me that Oracle doesn't permit a check constraint

to


> reference another table.

>

> Is there a relatively clean way of doing this?  I know I could do it with

> triggers, but I'm concerned that I'm merely replacing complexity with

another


> form of complexity.

>

> --

> John Bossert

>

> In what concerns you much, do not think that you

> have companions: know that you are alone in the world.

>

>              -- Henry David Thoreau

>