oracle退出session的隐式提交事务,小心,小心

最新推荐文章于 2024-08-13 18:26:51 发布

rudy_gao

最新推荐文章于 2024-08-13 18:26:51 发布

阅读量1.1k

点赞数

分类专栏： oracle_basic

本文链接：https://blog.csdn.net/rudygao/article/details/39580833

版权

oracle_basic 专栏收录该内容

127 篇文章 2 订阅

订阅专栏

SQL> create table t (id number);

Table created.

SQL> select * from t;

no rows selected

SQL> insert into t(id) values(1);

1 row created.

--此处直接退出session,没有显示提交事务,但oracle进行了隐式提交了事务,小心小心
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@rudy ~]$ sqlplus rudy/rudy

SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 26 15:11:48 2014

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Last Successful login time: Fri Sep 26 2014 15:10:56 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

--验证事务的隐式提交
SQL> select * from t;

ID
----------
1