Re: Please Help on Decode statement

On Tue, 11 Nov 1997 22:07:18 -0000, "Mujahid Hamid" <mujahid_at_pharmco.demon.co.uk> wrote:

>I am a new PL/Sql Programmer (Oracle 7.3)
>
>I am trying to use decode as following but it does not work; I trying to
>avoid using a complex 'if then else' statement by the use of decode:
>
>v_new_value:=decode(v_name,'one',1,'two',2,'0')
>
>the error message I get is : you must use decode within sql.
>
>If I use decode with a select then it works eg:
>
>select decode(v_name,'one'1,'two,2) from table
>
>help me please
>
>Cheers.
>

Hi Mujahid,

using decode with the dual table will do what you want: select decode(v_name,'one'1,'two,2) from dual

HTH,
Peter

Peter Schneider
pschneider.ctj_at_metronet.de Received on Wed Nov 12 1997 - 00:00:00 CST