CREATE TRIGGER "XVIEW"."trg_inDate"
BEFORE INSERT
ON "XVIEW"."test1" FOR EACH ROW
BEGIN ATOMIC
DECLARE "temp_id" BIGINT;
SET "temp_id" = NEXTVAL FOR insert_seq_test1;
SET "XVIEW"."test1".id="temp_id";
END "XVIEW"."trg_inDate"
其中 insert_seq_test1 是序列。
I