sqlplus question

[steeve123]

In SQL*Plus: Release 3.3.2.0.2
When a select statement return a lot of rows.
It puts a little windows with a button "cancel".
So when i want i click cancel and the query stops.

And when the query is to long, i just click cancel and i can rewrite my select statement.

BUT, In SQL*Plus: Release 8.0.6.0.0
I dont have that little window with a possiblility to cancel.
i have to do file/cancel.

THATS A PAIN IN THE %!!$$.

And when the query takes to long to run, the program seems to be frozen with no way to cancel, so i have to waits dozens of minutes.

What can i do to have that cancel feature that was in
SQL*Plus: Release 3.3.2.0.2.





[Edited by steeve123 on 07-11-2001 at 11:25 AM]

[Sdeutsch]

I usually do a ctrl-c or an ab end (through End Task) when things aren't going like I had planned or I need to break out. I agree, it was easier with the CANCEL option...

[dwfink]

Use the SQL*Plus command set pause to add in this kind of fucntionality. It won't bring up a text box, but it will restrict display to one page at a time. If you don't want to continue to the next page, use CTL-C to terminate the query and return to the SQL*Plus prompt.
It is best to add text to the pause to remind yourself. To use it automatically, add it to your glogin.sql

set pause "Press Enter to display next page"



[Edited by dwfink on 07-11-2001 at 11:49 AM]

[steeve123]

its a solution but not that super feature of sqlplus 3.

and what can i do for
when the query takes to long to run, the program seems to be frozen with no way to cancel, so i have to waits dozens of minutes.

What can i do to have that cancel feature that was in
SQL*Plus: Release 3.3.2.0.2.