Sorry, the right syntax is the following :


CREATE OR REPLACE trigger bi_t1
BEFORE INSERT ON T1
FOR EACH RAW
BEGIN
IF (:NEW.C11 LIKE '-%') THEN
:NEW.C11:=concat('P',:NEW.C11);
END IF;
END;