Difference between Decode and Case?
- 8 Answers
- 45057 Views
- Polaris, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pari
Decode
1.It’s a function
2.can compare only discrete vaules
3.Pl/Sql standards
4.cannot process null
Case
1.It's an Expression
2.can hande range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null
| Is This Answer Correct ? | 52 Yes | 11 No |
Post New Answer View All Answers
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
what is the difference b/w the refresh and buffered data?
Which versions are used in the bo dashboard work?
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
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
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
what is universe null
Explain which versions are used in the bo dashboard work?
Give some information on report bursting?
What is the difference between business requirement document and use case document.
What three things do you consider to be the most important factors for a manager?
Can Bo generates the Report from the cubical data Explain?
Explain in detail about type 2(scd),
What is the difference between user and versatile user?
What are the steps to do to use alerts in bo?
