Re: SQLPLUS Question
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 16 Jan 2010 23:19:27 +0000 (UTC)
Message-ID: <hithhv$d19$4_at_solani.org>
On Sat, 16 Jan 2010 20:24:36 +0000, Jeremy wrote:
>> 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?
Date: Sat, 16 Jan 2010 23:19:27 +0000 (UTC)
Message-ID: <hithhv$d19$4_at_solani.org>
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.
-- http://mgogala.freehostia.comReceived on Sat Jan 16 2010 - 17:19:27 CST