select seq.currval from tbl;在今天的实验中是不成功的;而select seq.nextval, seq.currval from tbl;就可以通过
...全文
2624打赏收藏
sequence的问题,nextval和currval
Oracle的Squence有两个属性,nextval和currval,可以在Sql语句中调用。但是编程时发现,在一个Connection中,只有出现过nextval之后才可以调用currval。比如: select seq.currval from tbl;在今天的实验中是不成功的;而select seq.nextval, seq.currval from tbl;就可以通过