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 universe null
What are the data types present in bo? What happens if we implement view in the designer and report?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What is aggregate table and aggregate fact table ... Any examples of both?
What we need to discuss with designer before starting the universe designing.
How many universes can be created in a project?
What is a bo repository?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
what are the tables used in health care domain project and columns used in report?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
in sap bi we have wad, then why we go for sap bo
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
how get the grand total in master-detail report?
What are all difference between business objects 6.5 and xi r2?