select for update 版本问题

最新推荐文章于 2024-01-01 23:30:52 发布

ciqiangao5843

最新推荐文章于 2024-01-01 23:30:52 发布

阅读量193

点赞数

文章标签：数据库

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
PL/SQL Release 8.1.7.3.0 - Production
CORE 8.1.7.0.0 Production

TNS for IBM/AIX RISC System/6000: Version 8.1.7.3.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

SQL> select distinct sid from v$mystat;

   SID
----------
   248
SQL> select inventory_item_id from mtl_system_items_b where  inventory_item_id=214 for update;

INVENTORY_ITEM_ID
-----------------
            214
            214
            214
            214
            214

SQL> select session_id,lock_type,mode_held from dba_locks where session_id=248;

SESSION_ID LOCK_TYPE                MODE_HELD
---------- -------------------------- ----------------------------------------
   248 Transaction             Exclusive
   248 DML                      Row-S (SS)

---------------------------------------------------------------------------------------------------------------
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> select distinct sid from v$mystat;

   SID
----------
      38
SQL> select inventory_item_id from mtl_system_items_b where inventory_item_id=214 for update;

INVENTORY_ITEM_ID
-----------------
            214
            214
            214
            214
            214
SQL> select session_id,lock_type,mode_held from dba_locks where session_id=38;

SESSION_ID LOCK_TYPE                MODE_HELD
---------- -------------------------- ----------------------------------------
      38 Transaction             Exclusive
      38 DML                       Row-X (SX)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7192804/viewspace-346789/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7192804/viewspace-346789/