SQL & PL/SQL

Hi,

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