Last updated on APRIL 21, 2017
Applies to:SQL*Plus - Version 126.96.36.199 and later
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.
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