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.