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.