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
Explain about normal forms?
How long can an error message be in raiseerror function?
What is an application role and explain a scenario when you would use one?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What are data modelling techniques?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Explain about post-relational databases?
Which four data types cannot be used as a return type from a user-defined function?
What is dbms and its application?
How would you design a database for an online site, which would average a million hits a day?
Explain about relational database management systems?
What is DB Development software?
What is dbms explain in brief?
Explain about query and reporting.