Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
SAVEPOINT to UPDATE, 4 of 9
Use the SET
CONSTRAINTS
statement to specify, for a particular transaction, whether a deferrable constraint is checked following each DML statement or when the transaction is committed.
To specify when a deferrable constraint is checked, you must have SELECT
privilege on the table to which the constraint is applied unless the table is in your schema.
set_constraints::=
set_constraints
Specify the name of one or more integrity constraints.
Specify ALL
to set all deferrable constraints for this transaction.
Specify IMMEDIATE
to indicate that the conditions specified by the deferrable constraint are checked immediately after each DML statement.
Specify DEFERRED
to indicate that the conditions specified by the deferrable constraint are checked when the transaction is committed.
The following statement sets all deferrable constraints in this transaction to be checked immediately following each DML statement:
SET CONSTRAINTS ALL IMMEDIATE;
The following statement checks three deferred constraints when the transaction is committed:
SET CONSTRAINTS emp_job_nn, emp_salary_min, hr.emp_job_fk@houston DEFERRED;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|