Re: Really annoying change to 11.2 sqlplus

From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Fri, 25 Feb 2011 10:26:47 -0800
Message-ID: <AANLkTi=zOOo7_cvGWpkexadRiJa+jQz7gspWUTrM2-6r_at_mail.gmail.com>

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

On Fri, Feb 25, 2011 at 8:09 AM, Yong Huang <yong321_at_yahoo.com> wrote:

> > If you want to retain the DOS window when you intentionally hit
> > control-c, you can set your sqlplus shortcut target to
> > "C:\Windows\System32\cmd.exe /k sqlplus"
>
> That's true. But there's no way to avoid exiting Sqlplus, although
> Control-C doesn't always exit. I had an enhancement request in 2009
> https://support.oracle.com/CSP/main/article?cmd=show&type=BUG&id=8890996
> but it didn't catch their attention. I think all their developers need
> to do is add code SetConsoleCtrlHandler().
>
> Related. Here's what I said in an article about Windows Sqlplus (which
> is gone in 11g):
>
> Having said all these, the Windows version Sqlplus does have some unique
> features missing in the DOS version:
>
> * Windows Sqlplus never exits out of Sqlplus when you press Control-C
> (UNIX/Linux sqlplus doesn't either), while DOS Sqlplus may. Hopefully
> Enhancement Request 8890996 will finally get Oracle's attention.
> * The Windows Sqlplus has much more powerful special character
> display than the DOS version. Try
> select chr(49833) copyright from dual;
> in both to see what I mean. The weak capability of the DOS version could
> be dangerous in some cases; if the text column has two Carriage Return's,
> the Windows Sqlplus shows a rectangular dot but the DOS version silently
> "erases" the first part of the text. Try
> select 'x'||chr(13)||'y'||chr(13)||'z' from dual;
> The behavior doesn't change with different NLS_LANG settings.
>
> Yong Huang
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Fri Feb 25 2011 - 12:26:47 CST