...
UPDATE xdepartment SET TREEID = '0102'||SUBSTR(TREEID,5)
WHERE TREEID LIKE '0101%';
...
解决方案 »
- orcle9i导入dmp文件出了问题
- 用form 10g打开form 6i开发的form文件报错!
- 新手求助:关于一个存储过程改造
- startup报ORA-19802,shotdown报ORA-01034和ORA-27101,问题很奇怪,请帮忙看看。
- 中文为什么是乱码?
- orcle連接问题
- 请问ORA-01113: file 1 needs media recovery ,ORA-01110: data file 1: 'D:\BACKUPDB\SYSTEM01.DBF' 是什么错误,怎么解决?
- proc中ROLLBACK WORK RELEASE和ROLLBACK RELEASE有何异同?
- sql语句问题,等待……
- 关于ORA卡硬盘一说
- ORACLE改SQL问题
- OIP-04109: Error creating temporary file
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;