Lock oracle records when querying records

The oracle record locking method may not be available to everyone. The following describes how to implement oracle record locking. If you are interested in this, take a look.

Implementation of oracle record lock:

Using the select for update clause

Conn system/manager

-- Create lab user
Grant connect, resource to test identified by test;

Conn test/test

-- Create lab table 1
Create table a (a number );
Insert into a values (1 );
Commit;

Select * from a for update;
Or
Select * from a for update of a. a; column a of table)

-- A New SQL * Plus window is opened.
Conn test/testtest user's second session)
Delete from;

At this point, the system pauses and waits for unlocking,
You can unlock the roll or commit command in the first window.

Introduction to Oracle Process Structure

Learn more about Oracle tablespace

Three phases of Oracle Startup Mode

Oracle conversion functions

Use dynamic SQL for Oracle stored procedures