Write the difference between case version and decode version.
- 2 Answers
- 3740 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
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
What is dbms explain in brief?
Which four data types cannot be used as a return type from a user-defined function?
Explain about the relational database?
Explain about the database management systems.
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How you can make a parameterized view?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
Can an extended stored procedure be called from inside a user-defined function?
Explain about relational operator join?
What is dbms and its application?
Who are end users in dbms?
Which data type cannot be used as a parameter in a udf?
How long can an error message be in raiseerror function?
What are the main phases of database development?
