Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Ctrl-C in sqlplus

unknown-3431574Aug 22 2017 — edited Aug 25 2017

One of my pet hates when running sqlplus on windows is that, whereas I can use Ctrl-C to stop a query in sqlplus on Linux/Unix, retaining my sqlplus session, on Windows it ends the sqlplus session completely.

I've searched the internet for solutions to this and found none, the general consensus appears to be "you're stuck with it".

However, I've recently noticed that, when connecting to the office via the Anyconnect VPN software, issuing Ctrl-C when using sqlplus on windows only terminates the query, not the sqlplus session.  So it appears that there is some way of preventing the sqlplus session from ending.

I assume it's somehow related to how the VPN software processes keyboard input, but it does imply that there is a control code that can be sent to sqlplus to simply stop the query.

Does anybody have any idea what this might be?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2017
Added on Aug 22 2017
7 comments
5,140 views