trying to use sqlplus to do a build and making it dynamic
Date: Wed, 4 Jun 2008 13:05:51 -0400
Message-ID: <81f4c0700806041005xeb1fcdft962f8528080438f4@mail.gmail.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 04 2008 - 12:05:51 CDT