Difference between Decode and Case?
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 is the difference between slice and dice and cross tab report?
What is the difference between condition & filter?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Can we Save (save as) WEBI Doc as DESKI?
Give some information on report bursting?
What is the difference between datawarehousing and businessintelligence?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what three things do you consider to be the most important factors for a manager?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What are the steps to do to use alerts in bo?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
what are the tables used in health care domain project and columns used in report?
What is thumbnail?
what is the difference b/w the refresh and buffered data?