首页 > 代码库 > SAVEPOINT 标记
SAVEPOINT 标记
create table duo( --创建表格
v_xuhao number(3),
v_name varchar2(10),
v_job varchar2(10),
v_time date
);
insert into duo values (001, --添加内容
‘李颖‘,
‘经理‘,
to_date(‘2011-05-20‘,‘YYYY-mm-dd‘)
);
SAVEPOINT A; --标记为A点
insert into duo values (002,
‘张强‘,
‘店长‘,
to_date(‘2014-06-27‘,‘YYYY-mm-dd‘)
);
insert into duo values (003,
‘李明‘,
‘店员‘,
to_date(‘2015-01-27‘,‘YYYY-mm-dd‘)
);
SAVEPOINT B; --标记为B
insert into duo values (004,
‘照抄‘,
‘店员‘,
to_date(‘2016-05-27‘,‘YYYY-mm-dd‘)
);
commit; --提交
delete from duo
where v_xuhao=2;
ROLLBACK
to SAVEPOINT B;
select * from duo
SAVEPOINT 标记