Re: trying to use sqlplus to do a build and making it dynamic
Date: Wed, 4 Jun 2008 14:37:55 -0700
Here's a book you will find quite useful:
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
> 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-lReceived on Wed Jun 04 2008 - 16:37:55 CDT