Thread: decode or case statements

decode or case statements

From
"Priya, Nagappan (N.)"
Date:
Hi,
Please help me in forming a select statement using decode functionality or case in oracle and sql seperately.

The scenario is if  a field has some value like 999999 then we had to select 0 for all the through out the table .
Please give ur answersRegards
Priya.N