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.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.