Insert Into....Select

[Guest_imported]

Hi

I'm using an "Insert into....Select" statement to process and insert rows from one table into another. The average no. of rows inserted is about 200,000.

The statment may look like this:
INSERT INTO W_SALES
SELECT ITM , GRS_DMD
FROM Sales
WHERE TO_CHAR(DTE) = TO_CHAR(sysdate)

For every 5000 records, I need to COMMIT the records into the table.

How can I do this? For Some reason if the INSERT statement fails, is there a way that only a portion would have been inserted?

Thanks for the help.

 

[sem]

You may use cursor loop, but performance will degrade. Though you may try to improve it using BULK COLLECT