Home » SQL & PL/SQL » Client Tools » how to stop query execution in SQL*plus (merged 3) (Oracle 7/8/9)
how to stop query execution in SQL*plus (merged 3) [message #424625] Sun, 04 October 2009 23:41 Go to next message
NileshKS
Messages: 14
Registered: February 2009
Location: India
Junior Member

Hi,

I have run the query select * from tab; in SQL*Plus which contains huge data.How do I stop the execution without exiting from the editor.

Thanks
NKS
Re: how to stop query execution in SQL*plus [message #424627 is a reply to message #424625] Sun, 04 October 2009 23:45 Go to previous messageGo to next message
sen_sam86
Messages: 33
Registered: August 2009
Location: Chennai
Member
Just Give "Ctrl + C" then the execution will stop..
Re: how to stop query execution in SQL*plus [message #424631 is a reply to message #424625] Sun, 04 October 2009 23:55 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
How to master this web stuff?

http://www.orafaq.com/forum/t/150636/136107/
Re: how to stop query execution in SQL*plus (merged 3) [message #424635 is a reply to message #424625] Mon, 05 October 2009 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 63807
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is a windows SQL*PLus, click on File/Cancel.

Regards
Michel
Re: how to stop query execution in SQL*plus [message #424693 is a reply to message #424631] Mon, 05 October 2009 07:02 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
BlackSwan wrote on Mon, 05 October 2009 06:55
How to master this web stuff?

http://www.orafaq.com/forum/t/150636/136107/


I guess you're going to have to answer your question yourself Laughing


Re: how to stop query execution in SQL*plus [message #424706 is a reply to message #424693] Mon, 05 October 2009 07:40 Go to previous message
Michel Cadot
Messages: 63807
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The link is no more available because I merged the topics.

Regards
Michel
Previous Topic: Declaring variable in SQLPLUS command
Next Topic: Access violation at address
Goto Forum:
  


Current Time: Wed Sep 28 12:32:55 CDT 2016

Total time taken to generate the page: 0.22392 seconds