what is diff between Decode and case ? Give some Example?

Answer Posted / jj@hotmail.com

Decode is similiar to an if statement and is Oracle
specific. The Case statement is more universal. The case
statement is more efficient in that it will exit the logic
when it evaluates true. It is also easier to read.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the measure objects?

729


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

881


How to restrict password to a user while sending a document in .pdf format

2052


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1878


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9827


What are all difference between business objects 6.5 and xi r2?

790


Explain about a task that really tested your analytical abilities?

999


what is document design in boxi,have u participate in that

1837


What is difference between custom hierarchy and report based hierarchy?

770


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1026


What Is The Difference Between Oltp And Olap?

857


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2173


Explain what is the difference between business requirement document and use case document.

763


What is difference between webi and infoview?

876


Explain how to execute the plsql procedure from the report by clicking with mouse?

803