日期:2014-05-16  浏览次数:20441 次

db2和oracle查询序列区别

DB2中:nextval for sequencename ,prevval for sequencename

select nextval for seq_name from sysibm.sysdummy1;

select prevval for seq_name from sysibm.sysdummy1;

oracle中:sequencename.nextval,sequencename.currval

select seq_name.nextval from dual;

select seq_name.currval from dual;

sysibm.sysdummy1是DB2内存中的一个特殊的表.