Re: How do you stop query output from SQL*Worksheet?

Hello grakaska,
you can kill a session in your database. In oracle you do it the following way:

select sid,serial#,machine
from v$session
where machine like 'your machine' -- you don't need the where statement.

Then you type
alter system kill session '(your sid),(your serial#);

and that's it.
After that you have to end your connection to the database and restart it again.
Good luck
Corinna Becker

grakaska_at_indy.wrep.com wrote in article <3638e32f.167320_at_netnews.msn.com>...
> I issued a query from the command window of SQL* Worksheet (v1.3.6 OEM
> for NT). The results began scrolling in the output window. I could not
> issue a break sequence to stop the output. The cursor was the good old
> "hourglass" so I figured it wasn't one of the toolbar buttons. I tried
> Ctrl-C, Ctrl-Break, Esc, and all the function keys F1-F12. I know
> bringing up the task list, and hitting "end task" button will stop it,
> but that's not very elegant!
>
> Thanks in advance!
>
>
Received on Mon Nov 02 1998 - 05:43:19 CST