SQL*Plus Worksheet - How terminate a query???

[kamv]

Hi

I am editing/running a query using SQL*Plus Worksheet. The query returns many many records. I don't really care about how many records it returns I just want to make sure it works. My question is: After executing a query in SQL*Plus Worksheet how do I stop it while its running? How do I terminate it?
Thanks

Kamv

 

[THoey]

Have you tried just closing the SQL*Plus Worksheet? You could also use DBA Studio to Disconnect the user. These will cancel the job, but if a rollback is necessary, it may take some time...

Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[kamv]

Thanks for the response.
I tried closing the SQL*Plus Worksheet the problem with that was I think that the query continues to run (I could not log back in for a good 10 min.) There is no Ctrl key or function key command to stop the query?

Kamv

 

[jee]

I don't think there is a way to stop the query. In this case I would use SQL*PLUS because you can stop queries there with a Ctrl-C.