Question { Wipro, 45471 }
Difference between Decode and Case?
Answer
Decode
1.It’s a function
2.can compare only discrete vaules
3.Pl/Sql standards
4.cannot process null
Case
1.It's an Expression
2.can hande range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null