-
"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
-
Hi
SET PAUSE ON
This is a sqlplus utility setting..
regards
Hrishy
-
You may use DBMS_LOCK.SLEEP(TIME IN SECONDS) within the plsql script
Sathish
-
Q answered. Thanks to hrishy&Sathish.
-
...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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|