db2和oracle查询序列区别

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内存中的一个特殊的表.  www.zzzyk.com  

 

查看更多关于db2和oracle查询序列区别的详细内容...