B Automatic and Manual Locking Mechanisms During SQL Operations

This appendix describes mechanisms that lock data either automatically or as specified by the user during SQL statements. For a general discussion of locking mechanisms in the context of data concurrency and consistency, see Oracle Database Concepts.

This appendix contains the following sections:

• Automatic Locks in DML Operations

• Automatic Locks in DDL Operations

• Manual Data Locking