Example 1: Using the SET ALL CONSTRAINTS statement in interactive
    SQL

    SQL> att 'file mf_personnel_sql';
    SQL> set all constraints immediate;
    SQL> show constraint;
        Statement constraint evaluation default is DEFERRED (off)
        Statement constraint evaluation is IMMEDIATE (on)
    SQL> /*
    ***> Show the constraints
    ***> */
    SQL> show tables (constraints) job_history;
    Information for table JOB_HISTORY

    Table constraints for JOB_HISTORY:
    JOB_HISTORY_FOREIGN1
     Foreign Key constraint
     Column constraint for JOB_HISTORY.EMPLOYEE_ID
     Evaluated on COMMIT
     Source:
     JOB_HISTORY.EMPLOYEE_ID REFERENCES EMPLOYEES (EMPLOYEE_ID)

    JOB_HISTORY_FOREIGN2
     Foreign Key constraint
     Column constraint for JOB_HISTORY.JOB_CODE
     Evaluated on COMMIT
     Source:
     JOB_HISTORY.JOB_CODE REFERENCES JOBS (JOB_CODE)

    JOB_HISTORY_FOREIGN3
     Foreign Key constraint
     Column constraint for JOB_HISTORY.DEPARTMENT_CODE
     Evaluated on COMMIT
     Source:
     JOB_HISTORY.DEPARTMENT_CODE REFERENCES DEPARTMENTS (DEPARTMENT_CODE)

    Constraints referencing table JOB_HISTORY:
    No constraints found

    SQL> set all constraints deferred;
    SQL> show constraint;
    Statement constraint evaluation default is DEFERRED (off)
    Statement constraint evaluation is DEFERRED (off)
    SQL>