Re: Can ORACLE do this?

From: Brian Yan <by999_at_hotmail.com>
Date: Tue, 31 Aug 1999 16:21:11 GMT
Message-ID: <7qgvd7$rej$1@nnrp1.deja.com>

If I understand your question correctly, you can use trigger to complete this (for example, before insert trigger)

Brian Yan

---

This just represents my personal opinion. It doesn't represent my employer's opinion from any respective.

---

In article <7qgphk$mjr$1_at_nnrp1.deja.com>,   Todder <toddbrasseur_at_my-deja.com> wrote:
> How do you check data integrity when two columns are related but not
in
> the same table?
>
> An example would be having a system which keeps track of automobile
> inventory. In one table (Master) you have the serial number,
> manufacturer, etc. In another table (Detail) you have the serial
> number (Foreign Key), color, etc. Each manufacturer has its own list
> of colors that it uses. So when a serial number and color is entered,
> you need to verify that the color is allowed for the manufacturer of
> the automobile. My idea was to pass the serial number to a stored
> procedure that finds the manufacturer (from the header) and passes
back
> a list of valid colors.
>
> The check constraint would look like:
>
> CHECK (New.Color IN
> (SELECT Color FROM StoredProcedure(New.SerialNumber))
>
> Is this allowed in ORACLE? The database we are currently using allows
> this to compile but doesn't work.
>
> If not, how would you accomplish this type of check?
>
> Thanks in Advance
>
> Todd
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 31 1999 - 11:21:11 CDT