Hitting CTRL+C Exits SQL*Plus Session on Windows (Doc ID 1265407.1)

Last updated on APRIL 21, 2017

Applies to:

SQL*Plus - Version 8.1.7.0 and later
Generic Windows

Symptoms

Hitting Ctrl+C on Windows terminates SQL Plus session instead of interrupting the query.

When Pressing CTRL+C on Unix, it interrupts query and SQL Plus is still running. This is the expected behaviour, as from the documentation, e.g. : in the SQL*Plus® User's Guide and Reference, version 11.2 :

Stopping a Command while it is Running:
Suppose you have displayed the first page of a 50 page report and decide you do not need to see the rest of it.
Press Cancel, the system's interrupt character, which is usually CTRL+C. SQL*Plus stops the display.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms