An optional clause that can be specified with the RESERVING
clause. When you specify the WITH AUTO_LOCKING clause, Oracle Rdb
automatically locks any relations referenced from constraints and
triggers defined on the reserved relations when the referenced
relations are accessed from the constraints or triggers. If one
of these referenced relations is also a reserved relation, the
explicitly specified lock mode must not conflict with the lock
mode required by the constraint or trigger that references the
relation.
The default is WITH AUTO_LOCKING. Specify the WITH NOAUTO_LOCKING
clause if you do not want to use the auto-locking option.