Mybatis 获取当前序列和下一个序列值 以及在一个方法中写多条SQL 语句

目录

 

1、Mybatis 获取当前序列和下一个序列值

 

2、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>