Home » Other » 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: 33
Registered: August 2009
Location: Chennai
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: 26766
Registered: January 2009
Location: SoCal
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: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
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: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
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: Sun Aug 24 02:36:55 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.