DB Development Question:
Download Job Interview Questions and Answers PDF
What is the difference between case version and decode version?
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
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 Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How to create an external table? | What is the family trees and connection by clause? |