Difference between Decode and Case?

Answer Posted / reddy

decode is a function we cant use wfere clause
case is a statement we can use where clause

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1863


Difference between zabo and webi?

638


Differences between business objects and web intelligence reports?

655


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

818


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

9438






how to create metric universe ?

1897


What are the data types present in bo? What happens if we implement view in the designer and report?

622


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

4449


8. How much supervision have you typically received in your previous job?

1836


What is the difference between datawarehousing and businessintelligence?

621


What are the join problems comes appart from loop,chasm & fan Traps

1556


What is object stores?

583


Explain in detail about type 1?

658


What is the difference between user and versatile user?

585


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

1581