Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Implementing Constraints
Dear all,
In the oracle book, i found the following syntax in defining the constraint:
column dataytpe {CONSTRAINT constraint]
in_line_constraint
[defer_spec]
in_line_constraint :==
{[NOT] NULL
| PRIMARY KEY
.
.
.
defer_spec :==
[NOT DEFERRABLE | DEFERRABLE [INITIALLY {IMMEDIATE | DEFERRED}]
.
.
I don't understand why the DEFERABLE syntax can be used with the IMMEDIATE
syntax. From the book, the use of IMMEDIATE syntax indicate that the default
is to check this constraint at the end of every DML statement. But
DEFFERABLE means check when COMMIT.
It makes me confuse
THX Received on Sun Jul 01 2001 - 01:38:36 CDT
![]() |
![]() |