This discussion is archived
1 Reply Latest reply: Nov 19, 2012 6:19 AM by Jeff Smith SQLDev PM RSS

Spool ouput in  UTF8 with BOM encoding

974971 Newbie
Currently Being Moderated
I've a requirement to get data from Oracle tables in a flat file.I'm using sqlplus script for the same.But those flat files must be in UTF8 With BOM(Byte Order Mark) format .Can anyone tell me how to spool data to a flat file of UTF8 format by running a sqlplus script in windows environment.Do I need to use convert function for every column in sqlplus script?Im usisng Oracle DB 11g

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points