Home -> Usenet -> comp.databases.oracle -> [Beginner] DECODE

[Beginner] DECODE

From: franck lejeune <flejeune_at_etu.utc.fr>
Date: Thu, 13 Jun 2002 09:46:08 +0200
Message-ID: <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 - 09:46:08 CEST












Original text of this message