/*CREATE TABLE niu_a ( run_date DATE, ID NUMBER ); CREATE TABLE niu_b ( insert_date DATE, ID NUMBER ); CREATE OR REPLACE TRIGGER wait_insert AFTER INSERT ON apps.niu_a FOR EACH ROW DECLARE x_wait NUMBER; BEGIN x_wait := (:NEW.run_date - SYSDATE)*24*3600; IF x_wait > 0 THEN dbms_lock.sleep(x_wait); END IF; INSERT INTO niu_b(insert_date,id)values(SYSDATE,1); END;*/
比如 插入时间 是sysdate后2分钟,那么insert数据也会在2分钟之后完成。这样行么?
(
run_date DATE,
ID NUMBER
);
CREATE TABLE niu_b
(
insert_date DATE,
ID NUMBER
);
CREATE OR REPLACE TRIGGER wait_insert
AFTER INSERT ON apps.niu_a FOR EACH ROW
DECLARE
x_wait NUMBER;
BEGIN
x_wait := (:NEW.run_date - SYSDATE)*24*3600;
IF x_wait > 0 THEN
dbms_lock.sleep(x_wait);
END IF;
INSERT INTO niu_b(insert_date,id)values(SYSDATE,1);
END;*/