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