Difference between Decode and Case?
- 8 Answers
- 45059 Views
- Polaris, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / gurujothi
*CASE can only be used inside the SQL statement where as CASE can be used anywhere even as a parameter of a function or procedure.
*Decode can do equality check only but Case can do more logic comparisons such as <,>etc.,
*The Case will handle NULL differently
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What are the steps to do to use alerts in bo?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Explain in detail about type 2(scd),
how get the grand total in master-detail report?
What is the difference between user and versatile user?
Explain is there any default username & pwd for bo designer & supervisor?
How can you first report in Business Objects by using broadcast agent?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What is difference between custom hierarchy and report based hierarchy?
Explain is data mart?
how many reports have u created ? explain a few.
Is there any other repository domains rather than universe, security, document?
Explain which versions are used in the bo dashboard work?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
