Mybatis 获取当前序列和下一个序列值 以及在一个方法中写多条SQL 语句
目录
1、Mybatis 获取当前序列和下一个序列值
#获取当前序列值
select XXX_sequence.currval from dual
#获取下一个序列值
select XXX_sequence.Nextval from dual
2、Mybatis 在一个方法中写多条SQL 语句
<delete id="delete_XXXXX">
begin
delete from XXX1 where id=XXX;
delete from XXX2 where id=XXX;
delete from XXX3 where id=XXX;
end;
</delete>