Does anyone know how to break out of a long running query when you have pause enabled in the command line version of sqlplus on Windows?
On Unix/Linux you can just hit control-C, but on windows, this key combination dumps causes you to abort out of sqlplus.
Open a cmd.exe window and run sqlplus.exe
Then try this:
set pause 'Press ENTER to continue...'
set pause on
set pages 50
select text from dba_source;
Then after paging through two screens, try to stop the query from executing without getting booted from sqlplus.
Anyone have a workaround?