Sample Header Ad - 728x90

SQLPlus Padding in Query Results

1 vote
1 answer
411 views
I have several Oracle servers that exhibit a behavior I do not understand. I have identified a two node RAC in which one node exhibits the behavior, but the other node does not. RAC is not involved in the issue, but it dramatically reduces the differences between the servers experiencing the different behavior. Why is the following output different? Node 2 (expected behavior): SQL> select 'a' from dual; ' - a SQL> select 'abc' from dual; 'AB --- abc Node 1 (unexpected behavior): SQL> select 'a' from dual; 'A' --- a SQL> select 'abc' from dual; 'ABC' --------- abc These nodes are connecting to different instances of the same database. I have done a show all on both and verified that the sqlplus settings are identical.
Asked by Leigh Riffel (23884 rep)
Mar 11, 2014, 07:01 PM
Last activity: Apr 11, 2014, 03:53 AM