Write the difference between case version and decode version.
Answer Posted / nithya
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
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the main phases of database development?
What are the constraints on severity level in raiseerror?
Explain the role of indexing in databases?
In which database can extended stored procedures be added?
Explain about network model?
Explain the process of the user request and data generating?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
How to customize error conditions.
What is data modeling with example?
How you can make a parameterized view?
How to generate OIDS
Explain the cube operator?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What is the maximum length of an extended property?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on