CREATE OR REPLACE TRIGGER insert_sjqs_cleanBEFORE INSERT ON "Z_SJQS_CLEAN_DATA"FOR EACH ROWBEGINSELECT "z_sjqs_clean_sequence".nextval INTO :new.ID FROM dual;END;
语句是这样的
触发器的逻辑表应该是只读的,不能修改new的值。