Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create insert script automatically on schedule

Arif75Jul 5 2012 — edited Jul 7 2012
Hi i have one table where daily many records are inserted, and i want to take this newly inserted records as sql file because we need to insert the same records into another database.First i would like to know how to create this insert statement automatically and then i want to schedule this using dmbs_job.Actually now i am creating rows using toad it gives me the proper insert command and commit.
create table om_item (item_code varchar2(20), item_name varchar2(60))



insert into om_item values ('a','aaaa');
commit;

insert into om_item values('b','bbbb');
commit;


--i want the file to be as item_sysdate_withtime.sql having the above 2 statements  into it and the same should run and get generated at 10am to be sent as mail.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2012
Added on Jul 5 2012
18 comments
1,881 views