Re: [Beginner] DECODE
From: Jon Waterhouse <jonwaterhouse_at_gov.nf.ca>
Date: Thu, 13 Jun 2002 14:10:27 -0230
Message-ID: <3d08cb8b$1_at_news.mhogaming.com>
Date: Thu, 13 Jun 2002 14:10:27 -0230
Message-ID: <3d08cb8b$1_at_news.mhogaming.com>
Since when are PL/SQL and Oracle incompatible (or PL/SQL and SQLPlus for that matter?
"franck lejeune" <flejeune_at_etu.utc.fr> wrote in message
news:Pine.OSF.4.33.0206130942230.1179-100000_at_vega.utc.fr...
> Hi,
>
> Is it possible to start a script within a DECODE ...
>
> exemple :
>
> select DECODE(number,0,_at_test0,1,_at_test1,2,_at_test2 ...) from ...
>
> actually i'd like to insert differents values which depend on the number
> ...
>
> I know this don't work but i'd like to know how to do something like
> this... And i can't use PL/SQL, my system is Oracle...
>
> Franck.
>
Received on Thu Jun 13 2002 - 18:40:27 CEST