Interested to Buy Any Domain ? << Click Here >> for more details...
Write the difference between case version and decode version.
- 2 Answers
- 4800 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
How you can make a parameterized view?
What is database design and development?
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.
What is data modeling with example?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
What is a database development?
How to combine two function together?
Explain about query and reporting.
Why does this query return 0?
What is an application role and explain a scenario when you would use one?
What is DB Development software?
How can you fix a poorly performing query?
How to use online Backups?
How can I detect whether a given connection is blocked?
Explain about the hierarchical model of the database?
