Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Decode and Case?
- 8 Answers
- 47753 Views
- Polaris, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / suman vyas
1) Case Can work with logical operator other than '=' . such as < , > , = < , >=
where Decode performs an equality check only.
2) Decode can work as function inside SQL only,
where Case can work in Pl/Sql as a substitute of IF-THEN-ELSE.
3) Decode can not process Null , where Case can process Null.
4) Case expects datatype Consistency, Decode Dose not.
5) Decode is a function, where Case is a statement.
hope this will give u satisfied Answer for Difference Between CASE AND DECODE.
Thanks
Suman Vyas
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
Explain what are the measure objects?
Explain about a task that really tested your analytical abilities?
What is the profile and package?
What is package in BO
What Is Snow Flake Schema?
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?
Explain what are the steps to do to use alerts in bo?
What is the dense rank?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
What is the difference between datawarehousing and businessintelligence?
What is aggregate table and aggregate fact table ... Any examples of both?
When to use local filter and when to use global filter?
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 are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
