INSERT INTO SELECT with Commit option
hi all,
I am not pl/sql guy, need to looking for small help from you gurus.
I have below script which I am going to use to copy over few millions of rows via db-link, I want put this into pl/sql block with commit option every after 10K rows.
can anyone please help on this ?
INSERT INTO SCHEMA.TABLE_NAME
(COLUMN1,COLUMN2,COLUMN3)
SELECT
COLUMN1,COLUMN2,COLUMN3@DB-NAME DB
WHERE DATE > TO_DATE('2012/3/20 07:00:00','YYYY/MM/DD HH24:MI:SS') ;