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

Home -> Community -> Usenet -> c.d.o.misc -> Re: trigger: mutating table - how to work around?

Re: trigger: mutating table - how to work around?

From: Nick <aroughguy_at_nsp.toughguy.net>
Date: Sun, 3 Nov 2002 22:22:37 +1100
Message-ID: <1G7x9.23452$Sr6.690602@ozemail.com.au>


Exactly!

I did a search through 1000+ page thick SQL manual but I could find only DELETE CASCADE and SET NULL
hence the question.

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:5qr7sugc4tshs8afvdod2mfi43h27nt07n_at_4ax.com...
> On Sun, 3 Nov 2002 01:31:41 +1100, "Nick" <aroughguy_at_nsp.toughguy.net>
> wrote:
>
> >I don't know I can do that
> >How would the syntax be like?
> >Thanks
>
>
> delete restrict is the default.
>
> Other than that mere syntax questions are best answered by yourself by
> looking it up in the sql reference manual.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sun Nov 03 2002 - 05:22:37 CST

Original text of this message

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