Interested to Buy Any Domain ? << Click Here >> for more details...
Write the difference between case version and decode version.
- 2 Answers
- 4646 Views
- I also Faced
- E-Mail Answers
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 three types of database design?
What is the database development process?
What is normalization? Explain different levels of normalization?
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?
How to generate OIDS
Explain about post-relational databases?
Why does this query return 0?
Write the fastest query to find out how many rows exist in a table?
Explain about query and reporting.
What is an application role and explain a scenario when you would use one?
What is the physical representation for a many-to-many relationship?
Explain about the database management systems.
Which data type cannot be used as a parameter in a udf?
How to customize error conditions.
Can an extended stored procedure be called from inside a user-defined function?
