Re: trying to use sqlplus to do a build and making it dynamic

Have a look at the sqlplus documentation, especially the column command with the new_value parameter.
I do that a lot. E.g. have a skeleton script which queries the database version and then executes a version-specific script. Or RAC vs non-RAC.

At 11:05 AM 6/4/2008, Rick Ricky wrote:
>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.

Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l