Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 3 of 4
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.
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 unq_name, scott.nn_sal, adams.pk_dept@dblink DEFERRED;
|
Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|