7 Replies Latest reply: Jul 28, 2009 10:35 AM by Sven W. RSS

    sqlplus spool file for chr(13)||chr(10).

    Beijing
      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