Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Decode and Case?
- 8 Answers
- 47647 Views
- Polaris, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / suman vyas
1) Case Can work with logical operator other than '=' . such as < , > , = < , >=
where Decode performs an equality check only.
2) Decode can work as function inside SQL only,
where Case can work in Pl/Sql as a substitute of IF-THEN-ELSE.
3) Decode can not process Null , where Case can process Null.
4) Case expects datatype Consistency, Decode Dose not.
5) Decode is a function, where Case is a statement.
hope this will give u satisfied Answer for Difference Between CASE AND DECODE.
Thanks
Suman Vyas
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
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 ?
Explain is there any other repository domains rather than universe, security, document?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
How can you first report in Business Objects by using broadcast agent?
What is the difference between business requirement document and use case document.
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?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
Explain in detail about type 1?
What is thumbnail?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what are the measure objects?
is it possible to export the webi reports to crystal reports?with out using businessview?
What is difference between custom hierarchy and report based hierarchy?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
