declare
..
begin
begin
delete from t_base_info where id=base_id;
commit;
exception
when others then
dbms_output.put_line('错误信息');
rollback;
end ;
begin
delete from t_segment_info where .......
commit;
exception
when others then
dbms_output.put_line('错误信息');
rollback;
end ;
begin
delete from t_relational_info where relation_from=base_id;
commit;
exception
when others then
dbms_output.put_line('错误信息');
rollback;
end ;
begin
delete from t_block_info where .......;
commit;
exception
when others then
dbms_output.put_line('错误信息');
rollback;
end ;end;
..
begin
begin
delete from t_base_info where id=base_id;
commit;
exception
when others then
dbms_output.put_line('错误信息');
rollback;
end ;
begin
delete from t_segment_info where .......
commit;
exception
when others then
dbms_output.put_line('错误信息');
rollback;
end ;
begin
delete from t_relational_info where relation_from=base_id;
commit;
exception
when others then
dbms_output.put_line('错误信息');
rollback;
end ;
begin
delete from t_block_info where .......;
commit;
exception
when others then
dbms_output.put_line('错误信息');
rollback;
end ;end;
解决方案 »
- 求个SQL语句
- UNION改变了字段类型,如何解决这个问题
- SOS,oracle创建库内存分配
- 远程连接一个oracle数据库 监听该怎么配??
- 这样的SQL语句要怎么写?
- 数据库表更改字段名的问题
- 请大家总结一下所有的oracle的命令和作用
- 请问oracle中的date型字段默认是DD-MON-YY(年月日),但它是支持精确到时分秒的,请问到时分秒的格式是什么?
- 怎样用数据库触发器进行历史记录保存???
- 请问 在ORACLE8怎么使用数组!!!!急. 急..
- 商业企业一般会对软件做哪些需求,我刚做商业系统项目实施,最怕财务的问问题
- 刚搞oracle9,oms中怎么没有我建好的数据库啊,独立启动可以看到所有的数据库,我该如何让oms里也有我建的数据库!(100分答玩就结)
delete from t_base_info where id=base_id;
delete from t_segment_info where .......
delete from t_block_info where .......
delete from t_relational_info where relation_from=base_id;
commit;
exception
when others
dbms_output.put_line(SQLCode||SqlErrm);
rollback;
end;
end;