ALTER TABLE child_table ADD CONSTRAINT frpp_report_id_fk FOREIGN KEY (FRPP_RUN_ID) REFERENCES parent_table (FRPP_RUN_ID) ENABLE VALIDATE
The job procedure below inserts an ID that is incremented by 1 every 10 minutes, into the table TEST.
DECLARE X NUMBER; BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what => 'insert into table test (ID) values (sequence_name.NEXTVAL);' ,next_date => to_date('27/08/2006 17:41:13','dd/mm/yyyy hh24:mi:ss') ,interval => 'SYSDATE+10/1440 ' ,no_parse => FALSE ); END;
Dig deeper on Using Oracle PL-SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.