Re: Really annoying change to 11.2 sqlplus
From: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 25 Feb 2011 08:09:39 -0800 (PST)
Message-ID: <862659.76262.qm_at_web80604.mail.mud.yahoo.com>
> 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"
Date: Fri, 25 Feb 2011 08:09:39 -0800 (PST)
Message-ID: <862659.76262.qm_at_web80604.mail.mud.yahoo.com>
> 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-lReceived on Fri Feb 25 2011 - 10:09:39 CST