Difference between Decode and Case?
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
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Did you face any problems while creating reports? Name? Solutions?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain how we drill up week to month?
What is difference between webi and infoview?
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?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
how to prepare the documentation in business objects and where to get the requirement?
Explain what are the measure objects?
What is the difference between slice and dice and cross tab report?
Explain about alerts in bos, under what situation we need to use alerts?
What is top business?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance