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!

sqlplus slpool - double hex 0A at the end of each data file.

734665Nov 17 2009 — edited Nov 17 2009
Hi,

I'm using sqlplus 11.2.0.1.0 instatnt client on FreeBSD for making a csv data file by running sql script.

Here are my sets:

SET SQLBLAKLINES OFF
SET HEADING OFF
SET FEED OFF
SET PAGESIZE 0
SET PAGES 0
SET TRIMSPOOL ON
SET TERM OFF
SET ECHO OFF

spool data.csv
...
(some code here)
...
spool off

But at the end of each data.csv I have double 0A (in hex view) which are actually not result of "some code here".

How I can get rid of those double hex 0A?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2009
Added on Nov 17 2009
2 comments
450 views