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 spool file for chr(13)||chr(10).

BeijingJul 27 2009 — edited Jul 28 2009
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production


SET TERM OFF;      
SET HEADING OFF;   
SET PAGESIZE 0;
SET TRIMSPOOL ON;
SET FEEDBACK OFF;
SET LINESIZE 4000;  
SET RECSEP OFF;
SET ECHO OFF;
SET VERIFY OFF;

SELECT 'A'||CHR(13)||CHR(10)||'A'
FROM DUAL
Spool the sql to a file. We are expecting to get *41 OD OA 41* in file when view by binary, but we got *41 OD OD OA 41*. Oracle server is on UNIX, File is generated on windows. Is there a way to solve this problem without change the sql statemnt (such as add replace function)?

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2009
Added on Jul 27 2009
7 comments
5,700 views