Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0
Connected as cognos@CDBANK
SQL> select * from IVR_CALL_LOG_HIS t
2 ;
TRAN_HISTORY_ID IN_TEL CHANNEL_NO UCID STD_DATE END_DATE CALL_LENGTH BATCH_PROC_CODE BATCH_DIS_CODE STAT_STATUS TRUNK_NUM FEE_PER
--------------- -------------------- ---------- ------------------------------------------------------------ ----------- ----------- ----------- --------------- -------------- ----------- --------- --------------------------------------------------
SQL> insert into IVR_CALL_LOG_HIS(in_tel,channel_no) values('1111111','2222');
1 row inserted
SQL> select * from IVR_CALL_LOG_HIS t;
TRAN_HISTORY_ID IN_TEL CHANNEL_NO UCID STD_DATE END_DATE CALL_LENGTH BATCH_PROC_CODE BATCH_DIS_CODE STAT_STATUS TRUNK_NUM FEE_PER
--------------- -------------------- ---------- ------------------------------------------------------------ ----------- ----------- ----------- --------------- -------------- ----------- --------- --------------------------------------------------
4169271 1111111 2222
rollback练习小例子
最新推荐文章于 2021-03-12 17:09:21 发布
本文通过一系列实例演示了数据库操作中的回滚操作。首先,插入一条数据并在未提交前查看;接着,删除数据但不提交,此时表显示为空;随后执行回滚操作,数据恢复到删除前的状态;接着,删除并提交数据,再尝试回滚时发现无法恢复数据,说明已提交的删除操作不能回滚;最后,讨论了TRUNCATE命令删除数据后的不可回滚性,并指出在PLSQL中可通过提交和回滚图标判断操作状态。
摘要由CSDN通过智能技术生成