Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can ORACLE do this?

Re: Can ORACLE do this?

From: Todder <toddbrasseur_at_my-deja.com>
Date: Tue, 31 Aug 1999 19:47:58 GMT
Message-ID: <7qhbha$568$1@nnrp1.deja.com>


Thanks for the reply!!!

I was hoping I wouldn't have to use triggers (Before Update, Before Insert) as it was much cleaner to use a stored procedure in the Check Constraint.

Oh well!!!

Todd

In article <7qgvd7$rej$1_at_nnrp1.deja.com>,   Brian Yan <by999_at_hotmail.com> wrote:
> 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.
>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US