Re: Set constraint to deferrable

From: Huberto Kusters <Huberto.Kusters_at_abp.nl>
Date: Fri, 25 Feb 2000 12:22:25 +0100
Message-ID: <895oll$h5r20@abp.nl>

Hi,

You have to issue the following command :

alter session set constraints = {deferred|immediate|default};

Regards,

Huberto

<jeanch_at_my-deja.com> schreef in berichtnieuws 893go2$pcc$1_at_nnrp1.deja.com...
> Folks,
>
> Does anyone know how to set a constraint
> to DEFERRABLE so that when I apply
> SET CONSTRAINT ALL DEFFERED the constraint moves
> from IMMEDIATE to DEFFERED;
> I cannot find the syntax for creating a constraint with flag
> to set it to deferrable;
>
> Any help is much appreaciated
>
> Cheers
> JC
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Feb 25 2000 - 05:22:25 CST