Difference between Decode and Case?
Answer Posted / pari
Decode
1.It’s a function
2.can compare only discrete vaules
3.Pl/Sql standards
4.cannot process null
Case
1.It's an Expression
2.can hande range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null
| Is This Answer Correct ? | 52 Yes | 11 No |
Post New Answer View All Answers
What is difference between custom hierarchy and report based hierarchy?
Explain when to use local filter and when to use global filter?
Difference between b.o 5.1 and 6.1b?
When to use local filter and when to use global filter?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
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?
What is report template in b.o?
Explain the difference between detect alias and detect context?
Differences between business objects and web intelligence reports?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
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 is document design in boxi,have u participate in that
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...