I am a beginner in Oracle and I need the help of you, no matter how simple questions seem. I am validating the creation of a script via SQL Plus and and the following errors appears below:
LINE/COL ERROR
3/5 PL/SQL: SQL Statement ignored
3/9 PL/SQL: ORA-00922: opção não encontrada ou inválida
CREATE OR REPLACE TRIGGER "TG_TESTES"
BEFORE UPDATE ON "TABELA_X"
BEGIN
IF (old.CAMPO_X = new.CAMPO_X) THEN
SET new.CAMPO_X = "F";
END IF;
END;
/
Thanks for any tip
ATT
ALESSANDRO