<div>
i have not worked on sql*plus worksheet, but in sql*plus we can try ctrl + c or esc key something like that.<br />
<br />
I think some expert on sql*plus worksheet has to hit this one.<br />
<br />
Thanks
</div>


i have not worked on sql*plus worksheet, but in sql*plus we can try ctrl + c or esc key something like that.

I think some expert on sql*plus worksheet has to hit this one.

Thanks

<div>
Great. I killed the process with another connection to the database.<br />
<br />
Thanks
</div>


Great. I killed the process with another connection to the database.

Thanks

<div>
<div class="content wysiwyg-content">
I am running a Oracle 8i on a windows 2000 environment.<br />
I tried to run a SQL command in the SQL*plus worksheet. When I try to display the contents in a table using &quot;select&quot;, I forgot to put in the &quot;where&quot; clause which resulted in the command running for a long long time because it is a huge table. Is there any way I can stop the command before it finishes?<br />
<br />
Thanks
</div>
</div>


I am running a Oracle 8i on a windows 2000 environment.
I tried to run a SQL command in the SQL*plus worksheet. When I try to display the contents in a table using "select", I forgot to put in the "where" clause which resulted in the command running for a long long time because it is a huge table. Is there any way I can stop the command before it finishes?

Thanks

How to stop running an Oracle SQL command

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.