1. 创建SEQUENCE
CREATE SEQUENCE "SCHEMA"."SEQ_USER_ID" AS BIGINT START WITH 1 INCREMENT BY 1
NO MINVALUE NO MAXVALUE NO CYCLE CACHE 20 NO ORDER
2. 使用SEQUENCE
User表结构如下:
CREATE TABLE USER (
USER_ID BIGINT NOT NULL,
USER_NAME CHARACTER(30),
PRIMARY KEY (USER_ID)
)
获取SEQUENCE的值:
-- method1: NEXTVAL FOR schema.sequence_name
INSERT INTO SCHEMA.USER(USER_ID, USER_NAME) VALUES(NEXTVAL FOR SCHEMA.SEQ_USER_ID, 'username1')
-- method2: query sql, 直接执行这个SQL可以获取到SEQUENCE值
VALUES NEXTVAL FOR schema.sequence_name