Re: Trigger to delete record from one table with check on another table.

From: Romeo Olympia <rolympia_at_hotmail.com>
Date: 26 May 2004 08:10:59 -0700
Message-ID: <42fc55dc.0405260710.2a1e8771_at_posting.google.com>

Don't you wanna use referential integrity constraints to achieve this?

kenneth.osenbroch_at_telenor.com (Kenneth Osenbroch) wrote in message news:<ce7df6a2.0405260105.55c4489_at_posting.google.com>...
> Hi. I want to create a trigger that only allows delete from table A if
> corresponding record in table B does not exist. Any idea on how this
> can be done? Thanks, Kenneth.
Received on Wed May 26 2004 - 17:10:59 CEST

This message: [ Message body ]
Next message: Ed prochak: "Re: Trigger to delete record from one table with check on another table."
Previous message: Bevertec: "Oracle Workflow - 6 mths - Jamaica/Canada - Bank"
In reply to Kenneth Osenbroch: "Trigger to delete record from one table with check on another table."
Next in thread: Ed prochak: "Re: Trigger to delete record from one table with check on another table."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message