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

From: Jared Still <>
Date: Wed, 4 Jun 2008 14:37:55 -0700
Message-ID: <>

Here's a book you will find quite useful:

On Wed, Jun 4, 2008 at 10:05 AM, 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.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Wed Jun 04 2008 - 16:37:55 CDT

Original text of this message