Обсуждение: decode or case statements

Поиск
Список
Период
Сортировка

decode or case statements

От
"Priya, Nagappan (N.)"
Дата:
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