Dump Oracle Tables To ASCII/Comma Delimited File
dump.sql is a utility to dump a single table to a comma and double quote delimited file. In addition, SQL*LOADER control and parameter files will be generated as well.

dump.sql will remove all double quotes from the data to avoid confusing SQL*LOADER. If you don't like this behavior, you may easily modify dump.sql to use a different delimiter, or skip using the quotes altogether.

The use of the quotes however, makes it possible for commas to appear in the data without confusing SQL*LOADER.

dump.sql in ASCII text