File generation using utl_file
Posted on 2016-11-13
i am generating a file using utl file package via plsql. I am wrapping each field with double quotes and seperating by comma. The generated file has problems when the vendor is trying to upload to their site.
iI tried to upload the generated file to google fusion table and it pointed me to the record where the problem was.
one of the field has double quote in it. something like this
field 1 field 2
Is there a special way to handle when there is an actual doule quote in the field. I know that in sqlloader you can specify occacionally enclosed by doule quotes while uploading. But how do i handle it while generating the file from database when the value contains double quote in it