Re: SQLPLUS Question
From: Jeremy <jeremy0505_at_gmail.com>
Date: Sun, 17 Jan 2010 16:34:24 -0000
Message-ID: <MPG.25bd4c701f5170ec9897ce_at_News.Individual.NET>
In article <hithhv$d19$4_at_solani.org>, gogala.mladen_at_gmail.com says...>
> On Sat, 16 Jan 2010 20:24:36 +0000, Jeremy wrote:
>
> > In article <hit6ej$phc$4_at_solani.org>, gogala.mladen_at_gmail.com says...>
> >> On Sat, 16 Jan 2010 18:37:24 +0000, Jeremy wrote:
> >>
> >>
> >> > Can you create sqlplus scripts with "conditions" such that if for
> >> > example a SQL statement returns a particular value or error condition
> >> > then path A or path B is followed?
> >>
> >> Yes. It's called PL/SQL and is available as of the version 6.
> >
> > Is that intended to be serious answer?
>
> Yes. That is precisely what PL/SQL is intended for: you run SQL and
> follow some logic path depending on the outcome.
Date: Sun, 17 Jan 2010 16:34:24 -0000
Message-ID: <MPG.25bd4c701f5170ec9897ce_at_News.Individual.NET>
In article <hithhv$d19$4_at_solani.org>, gogala.mladen_at_gmail.com says...>
> On Sat, 16 Jan 2010 20:24:36 +0000, Jeremy wrote:
>
> > In article <hit6ej$phc$4_at_solani.org>, gogala.mladen_at_gmail.com says...>
> >> On Sat, 16 Jan 2010 18:37:24 +0000, Jeremy wrote:
> >>
> >>
> >> > Can you create sqlplus scripts with "conditions" such that if for
> >> > example a SQL statement returns a particular value or error condition
> >> > then path A or path B is followed?
> >>
> >> Yes. It's called PL/SQL and is available as of the version 6.
> >
> > Is that intended to be serious answer?
>
> Yes. That is precisely what PL/SQL is intended for: you run SQL and
> follow some logic path depending on the outcome.
Perhaps I assumed I had conveyed more of my requirements to the post than I did.
It's about conditional execution of .sql files - am looking at ways to automate install/upgrades which cannot be done using PL/SQL.
-- jeremyReceived on Sun Jan 17 2010 - 10:34:24 CST