formatting issue - extra space between the columns in 11g client
627703Mar 4 2012 — edited Mar 4 2012Hi,
We recently upgraded the oracle client from 10g to 11g. The following script produces the different outputs when using the different oracle clients ( 10.2.0.2.0, 11.1.0.6.0). Both of clients connects to the same Oracle 11g database.
The output for Oracle 10g client (no extra space between the columns) -
ABC
ABC
The output for Oracle 11g client(having an extra space between the columns) -
A B C
A B C
The script that I used is
set serveroutput on
set verify off
set newpage 0
set space 0
set pagesize 0
set echo off
set feedback off
set termout off
set heading off
set colsep ""
set linesize 124
spool ./output.txt
column GEO_UNIT format a1 truncate
column RECORD_TYPE format a1 truncate
column SALES_FORCE_CODE format a2 truncate
SELECT 'A', 'B', 'C'
FROM TBL_XXX where rownum <3;
spool off
exit
I got the extra space between the columns using 11g client even I specified ZERO space between columns, how to get the same output as I got in Oracle 10g?
Thanks a lot for your help!
Liz