Interested to Buy Any Domain ? << Click Here >> for more details...
Write the difference between case version and decode version.
- 2 Answers
- 4908 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 is dbms and its application?
Why does this query return 0?
Explain about the storage and physical database design?
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
Explain about normal forms?
What are the types of database model?
What are the main phases of database development?
What are the three types of database design?
Explain what a database is?
How to replace not in with not exist?
What is data modeling with example?
What is database design and development?
Which four data types cannot be used as a return type from a user-defined function?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
