--創建一個序列
CREATE SEQUENCE test_sequence2
increment by 1start with 1
nomaxvalue
minvalue 1
NOCYCLE ;
--創建測試表
CREATE TABLE test_create_tab2 (
id INT,
val VARCHAR(10),
PRIMARY KEY (id)
);
--創建觸發器,一旦測試表插入其他字段,id字段就自動增長
CREATE OR REPLACE TRIGGER BeforeTestCreate2Insert
BEFORE INSERT ON test_create_tab2
FOR EACH ROW
BEGIN
SELECT test_sequence2.nextval INTO :new.id FROM dual;
END;
/
INSERT INTO test_create_tab2(val) VALUES ('NO id2');