RE: Really annoying change to 11.2 sqlplus

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Fri, 25 Feb 2011 13:46:07 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F676F6F3B_at_AAPQMAILBX02V.proque.st>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yong Huang Sent: Friday, February 25, 2011 1:40 PM
To: Michael Moore
Cc: steve.harville_at_gmail.com; oracle-l_at_freelists.org 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_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 25 2011 - 12:46:07 CST