Members   Search   Help    Register    Login   Home
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
Report message to a moderator
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: 23
Registered: August 2009
Location: Chennai
Junior Member
Just Give "Ctrl + C" then the execution will stop..
Report message to a moderator
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: 3367
Registered: January 2009
Senior Member
How to master this web stuff?

http://www.orafaq.com/forum/t/150636/136107/
Report message to a moderator
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: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
If it is a windows SQL*PLus, click on File/Cancel.

Regards
Michel
Report message to a moderator
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


Report message to a moderator
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: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
The link is no more available because I merged the topics.

Regards
Michel
Report message to a moderator
Previous Topic:Declaring variable in SQLPLUS command
Next Topic:Access violation at address
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 19:49:06 CST 2009

Total time taken to generate the page: 0.34613 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.