CASE is a statement and DECODE is a function
We can use the CASE in the where clause and can not use the DECODE in the where clause.
DECODE can check equality operators only where as CASE can support all relational operators
DECODE can be used in sql only where as CASE can be used in SQL AND PL/SQL
CASE is better than DECODE.
Thanks
ur's Hari
If you like this post, please share it by clicking on g+1 Button.
No comments:
Post a Comment