CREATE OR REPLACE TRIGGER TEST_ADD
BEFORE INSERT ON TEST.TEST_TRIGGER
FOR EACH ROW
declare
tname varchar(21);
i integer;
begin
i:=0;
tname:=:NEW.test_trigger.jh || :NEW.test_trigger.sjdwbh || i
UPDATE SET test_trigger.sj_id='+' || &tname& || '+';
i:=i+1;
end test_add;