DB

sequence nextval, currval

수학소년 2023. 5. 13. 22:45

MariaDB

select nextval(SCHEMA명.SEQUENCE명);
select lastval(SCHEMA명.SEQUENCE명);

 

Mysql

sequence 없음

 

DB2

SELECT SCHEMA명.SEQUENCE명.NEXTVAL FROM "SYSIBM".SYSDUMMY1;
SELECT SCHEMA명.SEQUENCE명.CURRVAL FROM "SYSIBM".SYSDUMMY1;

 

ORACLE

SELECT SCHEMA명.SEQUENCE명.NEXTVAL FROM DUAL;
SELECT SCHEMA명.SEQUENCE명.CURRVAL FROM DUAL;