Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Anyone know how to break an SQL-Plus Worksheet output stream?
dean wrote:
> Hello all,
>
> I don't know if there's a way to do a CTRL-BREAK when SQL-Plus
> Worksheet is outputting too-much data (say a million rows, which you
> have selected by mistake). What I do now is copy the SQL statement,and
> then just close the window and open another one, but that's a pain if
> you have a useful history of all the earlier statements.
>
> Thanks!
>
> Dean
Have your DBA set up a simple stored procedure for you so that you can see and kill only your own sessions.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Tue Dec 13 2005 - 11:12:28 CST