Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Anyone know how to break an SQL-Plus Worksheet output stream?

Re: Anyone know how to break an SQL-Plus Worksheet output stream?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 13 Dec 2005 09:12:28 -0800
Message-ID: <1134493943.199422@jetspin.drizzle.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US