`

sql中的回滚,回车

 
阅读更多

  sql11.append("declare begin savepoint bg;");
     sql11.append("update tb_hthx_info set GH_ID='"+gh_id+ "' where HTHX_ID='"+hthx_id+"' ; || chr(10)||");
     sql11.append("update   tb_guanhu set  guanhu_info='"+guanhu_info+"',create_time=sysdate where gh_id='"+gh_id+"'");
     sql11.append("commit; exception when others then   rollback to bg;  end;");

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics