RE: Really annoying change to 11.2 sqlplus
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "yong321@xxxxxxxxx" <yong321@xxxxxxxxx>, Michael Moore <michaeljmoore@xxxxxxxxx>
- Date: Fri, 25 Feb 2011 13:46:07 -0500
Isn't that just a side-effect of the way unix/Linux handle carriage returns and
line feeds?
If you replace chr(13) w/ chr(10), you may get what you were expecting:
SQL> select 'x'||chr(13)||'y'||chr(13)||'z' from dual;
'X'||
-----
z
SQL> c/13/10
1* select 'x'||chr(10)||'y'||chr(13)||'z' from dual
SQL> c/13/10
1* select 'x'||chr(10)||'y'||chr(10)||'z' from dual
SQL> /
'X'||
-----
x
y
z
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Yong Huang
Sent: Friday, February 25, 2011 1:40 PM
To: Michael Moore
Cc: steve.harville@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Really annoying change to 11.2 sqlplus
Vertial select is available in console (DOS) version of Sqlplus too. If you
haven't enabled QuickEdit mode, you have to go to Edit->Mark every time you
want to select.
Addition to my last message. sqlplus in UNIX/Linux terminal may also suffer
from the problem of characters disappearing when multiple chr(13) are in the
output, e.g.
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Feb 25 10:09:47 2011
...
SQL> select 'x'||chr(13)||'y'||chr(13)||'z' from dual;
'X'||
-----
z
Yong Huang
--- On Fri, 2/25/11, Michael Moore <michaeljmoore@xxxxxxxxx> wrote:
Also in the old win SQLPLUS you could highlight a column in the middle of the
window and copy it. That was very useful.
Mike
Other related posts:
