Well, that's unfortunate. I really thought Ctrl-C from sqlplus (from
command prompt) only interrupted the query - but it does indeed kick you
completely out of sqlplus . Grumble.
Chris
On Sun, Mar 10, 2019 at 4:01 PM Ram K <lambu999@xxxxxxxxx> wrote:
Thanks everyone who responded. Mark: Assuming the 'command prompt' SQL
Plus is launching SQLPlus from a DOS window by calling directly as:
"E:\app\oracle\product\12.2.0\dbhome_1\dbs\scripts>sqlplus <user>/<pwd>"
(rather than invoking the SQLplus directly by double clicking), that option
did not work either.
But the good news with the command prompt option is that if CtrlC kicks me
out to the command prompt all I have to do is press up arrow to get back
into SQLplus.
Ram.
On Sun, Mar 10, 2019 at 10:41 AM Mark W. Farnham <mwf@xxxxxxxx> wrote:
ah. using command prompt sqlplus versus the “gui” sqlplus may be
effective. Ram, can you switch to the command line version of sqlplus?
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Chris Taylor
*Sent:* Sunday, March 10, 2019 10:39 AM
*To:* lambu999@xxxxxxxxx
*Cc:* ORACLE-L
*Subject:* Re: Ctrl C in SQLPlus exits Windows
Ram,
Are you executing sqlplus from within another program such as
sqldeveloper? (Like execute SQL as a script)
The only time I've seen control-c exit sqlplus is if SQLplus is executed
from another program.
If you call sqlplus from the command prompt, I believe Ctrl-C will
interrupt as normal. You can save your sql scripts as ".sql" files if
you're writing them in a guide and execute script as @script or @<path to
script>/script.sql .
Chris
On Sun, Mar 10, 2019, 1:59 AM Ram K <lambu999@xxxxxxxxx> wrote:
Installed Oracle in my home Windows PC and playing around with it. But
pressing Ctrl-C always exits SQL Plus, when I run queries. grr... Tried
searching online and found this:
https://grokbase.com/t/freelists.org/oracle-l/095myarkwd/11g-sqlplus-on-windows-and-ctrl-c
Is there a solution for Ctrl C only to interrupt and not to exit SQL Plus
in windows.
--
Thanks,
Ram.
--
Thanks,
Ram.
