1.建表 (以下假设表名为 face_lib)
2.创建一个序列:
CREATE SEQUENCE face_lib_seq MINVALUE 1 START WITH 1 INCREMENT BY 1 NOCACHE;
3.创建触发器
CREATE TRIGGER face_lib_tig BEFORE INSERT ON face_lib FOR EACH ROW
BEGIN
IF :NEW.lib_face_id IS NULL THEN
SELECT
face_lib_seq.nextval INTO :NEW.lib_face_id
FROM
dual ;
END IF ;
END ;