sqlplus question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: sqlplus question

  1. #1
    Join Date
    Nov 2000
    Posts
    440
    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]

  2. #2
    Join Date
    Jul 2001
    Posts
    2

    ABEND

    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...

  3. #3
    Join Date
    Jun 2001
    Posts
    29
    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]
    Daniel W. Fink
    oracledba@ix.netcom.com

  4. #4
    Join Date
    Nov 2000
    Posts
    440
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width