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
Explain which versions are used in the bo dashboard work?
Explain what task is 98% of the required work of a business analyst?
What is a fantrap in business objects?
What is the difference between absolute and relative div positioning?
Explain difference between zabo and webi?
What are the join problems comes appart from loop,chasm & fan Traps
Explain the data types present in bo and what happens if we implement view in the designer and report?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain how we drill up week to month?
how to prepare the documentation in business objects and where to get the requirement?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain when to use local filter and when to use global filter?
What are all difference between business objects 6.5 and xi r2?
Differences between business objects and web intelligence reports?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...