---DB2查看系统的sequence
select seqschema,SEQNAME,INCREMENT,START,MAXVALUE from sysibm.syssequences
select nextval for SEQ_SEQNAME from sysibm.sysdummy1;
select currval for SEQ_SEQNAME from sysibm.sysdummy1;
---oracle查看系统的sequence
select SEQUENCE_NAME,MAX_VALUE,INCREMENT_BY,LAST_NUMBER from user_sequences
select nextval for SEQ_SEQNAME from dual;
select currval for SEQ_SEQNAME from dual;