Skip to Main Content
Forums

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!

Best way to populate 1 million rows into csv file from SQL query in Sqlplus or PL/SQL

Naga_SrinivasSep 28 2017 — edited Sep 29 2017

What is best way to populate 1 million rows into csv file from SQL query  using Sqlplus or PL/SQL

I tried using spool but it is taking more than 1 hour to  populate data into file.

I need records return by query should go to cav file with in minutes.

Please suggest.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 27 2017
Added on Sep 28 2017
21 comments
1,651 views