Execute Multiple SQL Scripts
Hi,
Need help in drafting a SQL script that achieves the following:
1. Accept a Parameter P3.
2. Run a Script S1.sql for P3 times
3. S1.sql accepts 2 parameters P1 and P2.
For example, the user interaction would look like this
Enter P3: 2
Enter P1: A
Enter P2: B
Enter P1: C
Enter P2: D
I've drafted the script S1.sql that accepts parameters P1 and P2, but I'm finding it difficult to implement the use of the Looping parameter as there is no SQL Plus Command for Looping.
Would really appreciate of any advice on this
0