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

From: Wolfgang Breitling <>
Date: Wed, 04 Jun 2008 12:27:37 -0600
Message-Id: <>

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.


Wolfgang Breitling
Centrex Consulting Corporation

Received on Wed Jun 04 2008 - 13:27:37 CDT

Original text of this message