How To Use Decode In Oracle
The Oracle ‘DECODE’ function/utility has the functionality of an ‘IF-THEN-ELSE’ declaration. It evaluates ‘expr’ to all ‘search’ rates one by one. If ‘expr’ is identical to a search then Oracle database precedes the equivalent result.
how to use decode in insert statement in oracle, oracle decode statement in where clause, if in where clause oracle, how to check not null in decode, sql null decode, using decode in sql, how to use like operator in sql for multiple values
http://www.inoracle.com/how-to-use-decode-in-oracle/