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

Here's a book you will find quite useful:

http://www.amazon.com/Mastering-Oracle-SQL-Plus/dp/1590594487

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

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