Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pause SQLPLUS on every Statement

sql_coderApr 30 2014 — edited May 2 2014

Hello,

Oracle 11.2, Topic SQLPLUS. I have a SQL file I cannot change. I am calling that file from SQLPLUS like @my_file.sql, so far no big deal. There are a lot of DML and DDL Statements in the file. Is there a way SQLPLUS will wait before executing the next command till I hit the Return key ? Again, I cannot edit the file.

sql_coder

Locked Post

New comments cannot be posted to this locked post.

Locked on May 30 2014

Added on Apr 30 2014

#general-database-discussions

25 comments

10,213 views