Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Decode and Case?
- 8 Answers
- 47767 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
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
what is document design in boxi,have u participate in that
What is the difference between business requirement document and use case document.
What are the join problems comes appart from loop,chasm & fan Traps
What is package in BO
What is the difference between absolute and relative div positioning?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What Is The Difference Between Oltp And Olap?
Can Bo generates the Report from the cubical data Explain?
What is the profile and package?
When to use local filter and when to use global filter?
any difficulitis have you phase while creating bo reports and how did u solve it
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
