Tuesday, December 09, 2008

Oracle Concate and Trigger

CREATE OR REPLACE TRIGGER TRIGGER1
BEFORE
INSERT ON A_LOG FOR EACH ROW

BEGIN
:NEW.ofis_refno:= :NEW.filename || '' || :NEW.logid;

END;

No comments: