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

Last updated on AUGUST 12, 2020

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.