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
