How to stop executing query?
Teymur, July 27, 2004 - 3:15 am UTC
Dear Tom.
If I started simple query on a big table (e.g: select * from t) which have 24.000.000.000 records, is it possible to stop it?..
Thanks inn advance.
Your site is ORACLE UNIVERSITY and FREE!!!
July 27, 2004 - 7:22 am UTC
ctl^c
or in your client, just stop fetching from it - close the cursor
How to stop executing query
Teymur, July 27, 2004 - 8:07 am UTC
Thanks for anwser.
I now this option in sqlplus. I am going to develop applicaton and could you please give me real world example how to write it (procedure or something else)?
Thanks in advance.
July 27, 2004 - 9:27 am UTC
depends on the language.
Java -- there is a "cancel" subroutine associated with statements.
ctl-c gets it in most cases.
totally depends on the environment however.