DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: "PAUSE" in sqlplus script

  1. #1
    31006558 Guest

    Angry "PAUSE" in sqlplus script

    I'm writing a script that I want to run in SQLPLUS. The firts part of the script produce an output that I want to use later in the script to make DDL changes.

    My problem: I want to "pause" the process after the first .sql so that the user can have a look at the results before he/she continues....this is very important because of the ddl procedure that will continue "on enter"

    Q:what is the correct syntex for a "pause" in a sqlplus script?

    Thnx a mil

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    SET PAUSE ON

    This is a sqlplus utility setting..

    regards
    Hrishy

  3. #3
    Join Date
    Nov 2002
    Posts
    39
    You may use DBMS_LOCK.SLEEP(TIME IN SECONDS) within the plsql script
    Sathish

  4. #4
    31006558 Guest

    Talking

    Q answered. Thanks to hrishy&Sathish.

  5. #5
    31006558 Guest
    ...and many thanks to SAMEER. The "SET SERVE...." is a great one!!

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