How to generate csv in oracle if it's query result return more than 32767 character per line in linux shell script
Linux – Oracle csv line size more than 32767
linuxoraclescripting
linuxoraclescripting
How to generate csv in oracle if it's query result return more than 32767 character per line in linux shell script
Best Answer
You can't use utl_file, since it has a maximum line length of 32767. It's possible that sqlplus has a similar limit. If you are tying to move data to a different Oracle database you can use data pump. You can eve use datapump on a materialized view. If you want to migrate to a non Oracle database you can use Perl or heterogeneous services to create a database connection to mySQL, SQL Server, etc. Then you won't have to worry about the line length.
UTL_FILE