Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Conditional Trigger
On Nov 28, 6:09 am, mowi..._at_hotmail.com wrote:
> Hi All,
>
> I solved the puzzle buy using two cursors. One cursor fetched all
> records that equaled :New.ISBN and the other fetched records in the
> periodical# column that equaled :New.periodical#_Owner.
>
> After that, I used a conditional check to ensure that if the ISBN
> being entered in the table already existed then periodical#_Owner was
> to be provided and that it had to be equal an existing periodical#.
>
> The trigger is working fine and I'm happy with it. Thanks to you all
> for your suggestions and helpful criticism; special thanks to David
> and Daniel.
>
> Regards,
> Mark
You're welcome.
David Fitzjarrell Received on Wed Nov 28 2007 - 07:41:04 CST