SQL*Plus (MOSC)

MOSC Banner

Diff in output between 11.2.0.1 and 11.2.0.3

edited Aug 1, 2012 6:54PM in SQL*Plus (MOSC) 4 commentsAnswered ✓
11.2.0.1


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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center