Re: SQLPLUS Question
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sat, 16 Jan 2010 23:10:32 +0100
Message-ID: <4b523893$0$2884$ba620e4c_at_news.skynet.be>
Gerard H. Pille schreef:
> Jeremy schreef:
>> 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?
>>
>>
>
> Ah, sorry to have underestimated you, Jeremy, but you must be brighter
> than you look, to see through him.
Date: Sat, 16 Jan 2010 23:10:32 +0100
Message-ID: <4b523893$0$2884$ba620e4c_at_news.skynet.be>
Gerard H. Pille schreef:
> Jeremy schreef:
>> 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?
>>
>>
>
> Ah, sorry to have underestimated you, Jeremy, but you must be brighter
> than you look, to see through him.
I have to correct myself, Mladen is right that you can use PL/SQL inside an sqlplus script. It could very well be that that is enough to solve your problem. Received on Sat Jan 16 2010 - 16:10:32 CST