Demo/GIFs for this in SQLcl here
https://www.thatjeffsmith.com/archive/2019/03/cancelling-in-oracle-sqlcl/
note that hitting ctrl+c won’t always give you immediate relief with the jdbc
driver on Oracle, it’s up to the db when it wants to really ‘let go’ – you
might find better responsiveness with a THICK/OCI connection.
Jeff
From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
Sent: Sunday, March 10, 2019 4:29 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Ctrl C in SQLPlus exits Windows
Hi Ram!
What would you like to interrupt? Interrupt signal is always dispatched to the
invoking process and it kills it. The sqlplus is not bad, it was just drawn
that way, to quote Jessica Rabbit. I would try with SQLcl, Java plug in
replacement for SQL*Plus. As I use Linux, I am not sure that this will work,
but it's worth trying. Jeff Smith can probably tell you more.
Regards
On 3/10/19 3:58 AM, Ram K 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:
HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=https-3A__grokbase.com_t_freelists.org_oracle-2Dl_095myarkwd_11g-2Dsqlplus-2Don-2Dwindows-2Dand-2Dctrl-2Dc&d=DwMDaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=1jvY6LMGdWRVzdRA6FObHu2Pcp9UR3j3seYUP9mHrP4&s=AMWSxS02FFmpM3LJ0DUFd99IBz2lgBGCIuj238HJvi8&e="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.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217