"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
SET PAUSE ON
This is a sqlplus utility setting..
You may use DBMS_LOCK.SLEEP(TIME IN SECONDS) within the plsql script
Q answered. Thanks to hrishy&Sathish.
...and many thanks to SAMEER. The "SET SERVE...." is a great one!!
Click Here to Expand Forum to Full Width