CREATE OR REPLACE TRIGGER trigger_name AFTER DELETE ON table_name FOR EACH ROW DECLARE BEGIN UPDATE xdepartment SET TREEID = '0102'||SUBSTR(TREEID,5) WHERE TREEID LIKE '0101%'; END;
CREATE OR REPLACE TRIGGER trigger_name AFTER DELETE ON table_name FOR EACH ROW DECLARE BEGIN UPDATE xdepartment SET TREEID = new.treeid ||SUBSTR(TREEID,length(treeid)-length(new.treeid)) WHERE TREEID LIKE old.treeid || '%'; END;
CREATE OR REPLACE TRIGGER trigger_name AFTER DELETE ON table_name FOR EACH ROW DECLARE BEGIN UPDATE xdepartment SET TREEID = '0102'||SUBSTR(TREEID,5) WHERE TREEID LIKE '0101%'; END;
CREATE OR REPLACE TRIGGER trigger_name
AFTER DELETE ON table_name
FOR EACH ROW
DECLARE
BEGIN
UPDATE xdepartment SET TREEID = '0102'||SUBSTR(TREEID,5)
WHERE TREEID LIKE '0101%';
END;
AFTER DELETE ON table_name
FOR EACH ROW
DECLARE
BEGIN
UPDATE xdepartment SET TREEID = new.treeid ||SUBSTR(TREEID,length(treeid)-length(new.treeid))
WHERE TREEID LIKE old.treeid || '%';
END;
AFTER DELETE ON table_name
FOR EACH ROW
DECLARE
BEGIN
UPDATE xdepartment SET TREEID = '0102'||SUBSTR(TREEID,5)
WHERE TREEID LIKE '0101%';
END;