SQL Language (MOSC)

MOSC Banner

Execute Multiple SQL Scripts

edited Jan 19, 2011 11:14AM in SQL Language (MOSC) 5 commentsAnswered
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


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center