DB Development Question: Download DB Development PDF

What is the difference between case version and decode version?

Tweet Share WhatsApp

Answer:

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

Download DB Development PDF Read All 10 DB Development Questions
Previous QuestionNext Question
How to create an external table?What is the family trees and connection by clause?