3,491
社区成员
发帖
与我相关
我的任务
分享
SQL> update emp set sal=8000 where empno=7369;
1 row updated
SQL> select sid,type,lmode from v$lock where sid=146;
SID TYPE LMODE
---------- ---- ----------
146 TM 3
146 TX 6
SQL> rollback;
Rollback complete
SQL> update emp set sal=8000 where to_char(hiredate,'yyyy-mm-dd')='1980-12-17';
1 row updated
SQL> select sid,type,lmode from v$lock where sid=146;
SID TYPE LMODE
---------- ---- ----------
146 TM 3
146 TX 6
SQL> rollback;
Rollback complete
SQL>