1  –  DEFAULT

    Syntax:

    DEFAULT | OFF

    Requests that during the next transaction, all constraints
    defined as DEFERRABLE INITIALLY DEFERRED be evaluated as
    originally specified in the constraint definition. OFF is
    synonymous with DEFAULT.

2  –  DEFERRED

    Synonymous with DEFAULT. However, in a future release of Oracle
    Rdb this keyword will change meaning.

3  –  IMMEDIATE

    Syntax:

    IMMEDIATE | ON

    This option requests that during this transaction, all
    constraints defined as DEFERRABLE INITIALLY DEFERRED be evaluated
    as though defined as DEFERRABLE INITIALLY IMMEDIATE. ON is
    synonymous with IMMEDIATE.

4  –  parameter

    Specifies the default character set for your session. The value
    of runtime-options must be a valid character set. For a list of
    allowable character set names and option values, see Oracle Rdb
    SQL Reference Manual.

5  –  parameter-marker

    Specifies the default character set for your session. The value
    of runtime-options must be a valid character set. For a list of
    allowable character set names and option values, see Oracle Rdb
    SQL Reference Manual.

6  –  'string-literal'

    Specifies the default character set for your session. The value
    of runtime-options must be a valid character set. For a list of
    allowable character set names and option values, see Oracle Rdb
    SQL Reference Manual.