If you are not changing the source file, then use SQL Loader, this is very fast.
Or UTL_FILE or external table will help.
If you are using 9i, then try PIPELINE fn. The real advantage of PIPELINE is it does not wait to fetch all the rows. As soon as it reads some rows, it will pass on to the calling routine.
Tamil




Reply With Quote