Skip to Main Content

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!

Write SQL data in a CSV file

User_19BPUJul 25 2020 — edited Jul 26 2020

Hi,

I am invoking a SQL in a shell script , i want to write the result set of the SQL in CSV file and upload to a server. Please let me know is there a way to write the SQL result set in a CSV file through Oracle DB. If we are unable to write the SQL result in a CSV file please let know we can do it through PL/SQL via Procedure and write the SQL data in a CSV file with the columns and rows with records?

Thanks

Comments
Post Details
Added on Jul 25 2020
6 comments
719 views