Run SQL*Plus Script That Runs Other Script files

Question

Ok, so I read this but I don't think the answer matches the question. I believe the OP is asking how to create a SQLPlus script that runs other SQLPlus scripts but the chosen answer reveals how to run a SQL script in SQL*Plus.

I would like to know how to create a SQLPlus script that, when run, executes other SQLPlus scripts within the same directory.

Answer 1

The given answer is correct. Create a directory with two files: control.sql second.sql

make control.sql contain:

set serveroutput on

prompt "Start of control"
/

@second.sql
/

prompt "End of control"
/

make second.sql contain:

prompt "Start of Second"
/

prompt "End of Second"
/

Then run control.sql