Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Decode and Case?
- 8 Answers
- 47648 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 Index to the table in the universe designer and how it improves the Query performence
Can we configure two instances of CMS pointing to two different CMS system databases?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What sort of existing documents should business analysts refer to when starting on a new project?
When we use aggregate awareness function in designer?
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
Explain which versions are used in the bo dashboard work?
How many universes can be created in a project?
Explain the difference between union and group?
Explain the difference between detect alias and detect context?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
How would you format some text using css to be verdana and bold?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What is the difference between business requirement document and use case document.
