Re: EXCEPTIONS INTO clause
From: Thomas J Kyte <tkyte_at_us.oracle.com>
Date: 1996/04/05
Message-ID: <4k3aa4$hqv_at_inet-nntp-gw-1.us.oracle.com>#1/1
opinions and statements are mine and do not necessarily reflect the opinions of Oracle Corporation. Received on Fri Apr 05 1996 - 00:00:00 CEST
Date: 1996/04/05
Message-ID: <4k3aa4$hqv_at_inet-nntp-gw-1.us.oracle.com>#1/1
chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:
>How does this clause work? Is it only used when enabling/creating a
>constraint to let you know what rows will be trouble makers? Or is it
>used to store the trouble makers that you try to update/insert?
>--
>Chuck Hamilton
>chuckh_at_ix.netcom.com
>If at first you don't succeed, skydiving isn't for you.
It is only used when enabling/creating a constraint to let you know what rows are the trouble makers. It does not do it for subsequent inserts/updates, they are rejected immediately without ever making it into the table.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
opinions and statements are mine and do not necessarily reflect the opinions of Oracle Corporation. Received on Fri Apr 05 1996 - 00:00:00 CEST