execute immediate 'select count(*) from '||:new.TableName into :new.Cnt ||'where orderDate>:v1' into :new.cnt using :new.TableTime;
execute immediate 'select count(*) from '||:new.TableName into :new.Cnt ||' where orderDate>:v1' into :new.cnt using :new.TableTime;
谢谢能解释一下 v1? using?小弟刚入门.
CREATE OR REPLACE TRIGGER Tri_TempA BEFORE INSERT ON TempA FOR EACH ROW Declare v_Cnt NUMBER; BEGIN execute immediate 'select count(*) from '|| :new.TableName ||' where orderDate>:v1' into :new.cnt using TRUNC(:new.TableTime,'DD'); END Tri_DateCheck;
BEFORE INSERT
ON TempA
FOR EACH ROW
Declare
v_Cnt NUMBER;
BEGIN
execute immediate 'select count(*) from '|| :new.TableName ||' where orderDate>:v1' into :new.cnt using TRUNC(:new.TableTime,'DD');
END Tri_DateCheck;
结!