Skip to Main Content

SQL & PL/SQL

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!

How to use parameters in oracle SQL script????

787787Jul 27 2010 — edited Jul 28 2010
Right now I am writing a SQL script to create a schema and build the objects of this schema....

I use a .net winform program to run sqlplus to parse this sql script ...

The problem is that the schema name and the tablespace's location and the sys password must be input by the user, so my SQL script should use these runtime input parameters instead of const parameters....

So, how to use parameter in SQL script ...........

Are there some example scripts in oracle home directory for me to refer to????
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2010
Added on Jul 27 2010
6 comments
27,394 views