db2和oracle查询序列区别
类别：DB2数据库 作者：码皇 来源：milife2012的专栏 点击：
db2和oracle查询序列区别DB2中：nextval for sequencename ，prevval for sequencenameselect nextval for seq_name from sysibm sysdummy1;select prevval for seq_name from sysibm sysdummy1;
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.2cto.com
相关热词搜索：
oracle 查询 序列
