CREATE TRIGGER TRI_NAME
AFTER INSERT
ON TEMP
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
DECLARE
v_c2 TEMP3.C2%TYPE;
BEGIN
SELECT c2 INTO v_c2 FROM TEMP2 WHERE C1 = :NEW.A1;
INSERT INTO TEMP1 ( b,b1,b2) VALUES (:NEW.A, :NEW.A1, v_c2);
END;
/
AFTER INSERT
ON TEMP
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
DECLARE
v_c2 TEMP3.C2%TYPE;
BEGIN
SELECT c2 INTO v_c2 FROM TEMP2 WHERE C1 = :NEW.A1;
INSERT INTO TEMP1 ( b,b1,b2) VALUES (:NEW.A, :NEW.A1, v_c2);
END;
/
解决方案 »
- oracle 行、列求和问题
- IMPDP命令执行中为什么会出现ORA-31684的错误。高手指点迷津
- 为什么我的这条sql语句执行这么慢,要40多秒
- ORACLE 9I 卸载后重新安装问题
- 急需一 select 写法 急!!!!!!!!!!!!!
- 更改user1的所有表的表空间后怎样重建所有的索引?
- Oracle9i 和SQLserver2000 同时安装在同一个win2003服务器上会不会出现兼容性问题?
- 错误:oracle ora-01704 (字符串过长),如何解决
- 优化、快速查询!!!
- oracle的SQL*PLUS到底是什么?
- j2ee 1.4server的deploytool中如何建立Oracle的数据源呢?
- 新手极急问题
after insert on temp
for each row
declare
c temp2.c2%type;
begin
select c2 into c from temp2where :new.a1=temp2.c1;
insert into temp1 (b,b1,b2) values (:new.a,:new.a1,c);
end;
CREATE TRIGGER TRI_NAME
AFTER INSERT
ON TEMP
FOR EACH ROW
DECLARE
v_c2 TEMP3.C2 varchar2(10);
BEGIN
SELECT c2 INTO v_c2 FROM TEMP2 WHERE C1 = :NEW.A1;
INSERT INTO TEMP1 ( b,b1,b2) VALUES (:NEW.A, :NEW.A1, v_c2);
END;
还是语法错误,大家帮忙再看看
v_c2 TEMP3.C2 varchar2(10); --这一句错了。应该是v_c2 TEMP3.C2%TYPE; 或者 v_c2 varchar2(10);
BEGIN