例如oracle 10g
savepoint sp;
op;
savepoint sp2;
op;
savepoint sp3;
op;
rollback;
请问是回到哪个保存点状态?
达人赐教!
savepoint sp;
op;
savepoint sp2;
op;
savepoint sp3;
op;
rollback;
请问是回到哪个保存点状态?
达人赐教!
解决方案 »
- 【高分求助】oracle里面blob类型另存图片的速度问题?
- oracle左外连接如何对应
- 删除视图时报错(You need an unconditional ON DELETE DO INSTEAD rule.
- string sql = "select * from '油井参数区L7-3366'"; 这样为什么不行???
- dblink insert数据到remote,varchar2型的字段,丢失.
- oracle数据库文档生成
- 怎么在oracle中插入大于4000的字符串?
- 如何得到某个用户的默认表空间和临时表空间????
- 神阿,救救我吧!急
- ubuntu 12.04 LTS 64bit 环境下安装Oracle 11g R2 时先决条件检查全部失败~求大神支招
- 这条SQL怎么写呢
- 在线求一SQL查询语句。。急!
savepoint sp;
op;
savepoint sp2;
op;
savepoint sp3;
op;
commit;--新添
rollback;
是否恢复到sp3的状态?
Table truncated
SQL>
SQL> begin
2 savepoint p1;
3 insert into t_test_transaction values(1);
4 savepoint p2;
5 insert into t_test_transaction values(2);
6 savepoint p3;
7 insert into t_test_transaction values(3);
8 rollback ;
9 commit;
10 end;
11 /
PL/SQL procedure successfully completed
SQL> select * from t_test_transaction;
ID
----------
SQL>
SQL> begin
2 savepoint p1;
3 insert into t_test_transaction values(1);
4 savepoint p2;
5 insert into t_test_transaction values(2);
6 savepoint p3;
7 insert into t_test_transaction values(3);
8 rollback to p2;
9 commit;
10 end;
11 /
PL/SQL procedure successfully completed
SQL> select * from t_test_transaction;
ID
----------
1
SQL>
op;
savepoint sp2;
op;
savepoint sp3;
op;
commit;--新添
savepoint sp4;
op;
rollback;
回滚到sp4。
已经commit的sp,无法回滚了。
2 savepoint p1;
3 insert into t_test_transaction values(1);
4 savepoint p2;
5 insert into t_test_transaction values(2);
6 commit;
7 savepoint p3;
8 insert into t_test_transaction values(3);
9 rollback to p2;
10 commit;
11 end;
12 /
begin
savepoint p1;
insert into t_test_transaction values(1);
savepoint p2;
insert into t_test_transaction values(2);
commit;
savepoint p3;
insert into t_test_transaction values(3);
rollback to p2;
commit;
end;
ORA-01086: 从未创建保存点 'P2'
ORA-06512: 在 line 10
SQL>