DB Development Interview Question:

What is the difference between case version and decode version?

Submitted by: Administrator

Decode
1.It's a function
2.can compare only discrete values
3.pl/sql standards
4.cannot process null

Case
1.It's an Expression
2.can handle range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null
Submitted by: Administrator