trying to use sqlplus to do a build and making it dynamic
Date: Wed, 4 Jun 2008 13:05:51 -0400
I can do this with a shell or with any other programming language and call sqlplus. I am trying to do this with just sqlplus scripts. I have code to do a build where I create tables, users, etc... Some of these can have some differences between databases (such as tablespaces) and some other things. I would prefer not to have to do:
prompt please enter tablespace name
I would like to use some form of configuration table. Is there anyway to do the following.
have a configuration table with data in it
query it in a script and put it in a variable. (this is easily done with
then pass that variable to a new script.
I would need to query the data and put it in some form of sqlplus variable that I can pass to another sqlplus script.Received on Wed Jun 04 2008 - 12:05:51 CDT