Oracle Database Discussions

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!

fast method to write query output to text file

122859Aug 21 2003 — edited Aug 21 2003

I want to know what are the different methods to write out a result set from a query to some delimited file? The source is a single table that has close to 100+ million rows.

I know I can turn off headings and spool off output to text file in SQL/PLUS. But that doesn't seems to be the faster way!

Thanks
kuman

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2003

Added on Aug 21 2003

#general-database-discussions

1 comment

590 views