Re: SQLPLUS Question

From: Jeremy <jeremy0505_at_gmail.com>
Date: Thu, 21 Jan 2010 21:25:19 -0000
Message-ID: <MPG.25c2d69a7ef54fb89897d7_at_News.Individual.NET>

In article <0b6c2d7b-eba1-4923-8127-
dd5b7dde582d_at_p24g2000yqm.googlegroups.com>, vladimir.zakharychev_at_gmail.com says...>

> >
> > It's about conditional execution of .sql files - am looking at ways to
> > automate install/upgrades which cannot be done using PL/SQL.
> >

>
> SQL*Plus can do a lot more than most people expect. Check out how
> folks at Oracle are doing it: take any recent CPU patch and inspect
> catcpu.sql and you'll immediately see a way to launch .sql scripts
> conditionally; or take a look at _at_?/rdbms/admin/catbundle.sql for more
> complex example of conditional script *generation* and execution. The
> technique itself is not new: you combine PL/SQL for evaluating
> conditions and choosing scripts to run, bind variables to convey
> arguments and hold results, and SQL*Plus user variables to actually
> launch chosen scripts, possibly with chosen arguments. These patch
> application scripts are an excellent example of the technique you can
> build on.

Many thanks, the best and most relevant response to this thread. Though to be fair, I'm glad we all know how to spell each other's names now.

-- 
jeremy

Received on Thu Jan 21 2010 - 15:25:19 CST