Difference between Decode and Case?
Answer Posted / zeya.ocp
CASE Expr make u use IF-THEN-ELSE logic in sql statements without to invoke procedure.It complies with ANSI SQL.
DECODE function decode an expr in a way similar to IF-THEN-ELSE logic that is used in various languages.it facilitate conditional inquiries.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
what is universe null
What is the difference in creating filters in designer and business objects?
Explain what are the measure objects?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
can anybody tell me about complicated object you have created
What would you consider as your biggest achievement and why?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How to open a universe with out using the Designer ??
Explain the data types present in bo and what happens if we implement view in the designer and report?
What is the difference between business requirement document and use case document.
Explain in detail about type 2(scd),
Which versions are used in the bo dashboard work?
8. How much supervision have you typically received in your previous job?