Two ways to modify tables in Oracle: pl/sqldeveloper

1. method 1 select * fromstudentforupdatestudent the table requires the operator to modify the commit before other operations can be performed. Otherwise, the table will be locked.

1. method 1 select * from student for update student the table can be operated only after the operator modifies the commit. Otherwise, the table will be locked.

I. method 1

Select * from student for update

The student table must be modified by the operator before other operations can be performed. Otherwise, the table will be locked.

Method 2

Select t. *, t. rowid from student t

Right-click a table in pl/SQL developer and the statement is displayed. The table is not locked.

If you want to modify several fields, select num, name, t. rowid from student t.

,