Re: Temporarely disabeling constraints

Rune Frøysa <runefr_at_gyda.ifi.uio.no> escreveu no artigo <w68yb3ws61m.fsf_at_levding.ifi.uio.no>...

> I have a table where the primary key is a foreign key in another
> table, and I want to change the value of this key. The bnf for sql-92
> indicates that the propper syntax to make oracle check constraints
> after performing both updates would be something like:
>
> SET TRANSACTION READ WRITE;
> SET CONSTRAINTS ALL DEFERRED;
> UPDATE main SET key=201 WHERE key=4;
> UPDATE refered SET key=201 WHERE key=4;
>
> This does not work under Oracle (sqlplus/oraperl with oracle v
> 7.2.2.3.0). What is the propper syntax for this kind of updates?
>

You'll have to use ORACLE8. That syntax only works with ORACLE8.

-- 

DANILO GIMENEZ
danilog_at_mandic.com.br
Sao Paulo - SP - Brasil