trying to use sqlplus to do a build and making it dynamic
- From: "Rick Ricky" <ricks12345@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- 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
accept tablespace
@mytablescripts &tablespace
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
pl/sql)
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.
Other related posts:
