Diff in output between 11.2.0.1 and 11.2.0.3
11.2.0.1
AL32UTF8
SQL> set heading off;
SQL> set colsep "";
SQL> SELECT '1V4A',sysdate from dual;
1V4A31-JUL-12
AL32UTF8
SQL> set heading off
SQL> set colsep ""
SQL> select 'AAAA',sysdate from dual;
AAAA 12-07-31
there are spaces between 'AAAA' and '12-07-31'
Why is it that there is a difference in Output with an extra space in 11.2.0.3? CURSOR_SHARING is exact on both instances.
Thanks,
Anand
AL32UTF8
SQL> set heading off;
SQL> set colsep "";
SQL> SELECT '1V4A',sysdate from dual;
1V4A31-JUL-12
11.2.0.3
AL32UTF8
SQL> set heading off
SQL> set colsep ""
SQL> select 'AAAA',sysdate from dual;
AAAA 12-07-31
there are spaces between 'AAAA' and '12-07-31'
Why is it that there is a difference in Output with an extra space in 11.2.0.3? CURSOR_SHARING is exact on both instances.
Thanks,
Anand
0