what is diff between Decode and case ? Give some Example?
- 2 Answers
- 6736 Views
- I also Faced
- E-Mail Answers
Answer Posted / jj@hotmail.com
Decode is similiar to an if statement and is Oracle
specific. The Case statement is more universal. The case
statement is more efficient in that it will exit the logic
when it evaluates true. It is also easier to read.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Can we create universe with no cache??
how to create metric universe ?
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
Explain about alerts in bos, under what situation we need to use alerts?
How to restrict password to a user while sending a document in .pdf format
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Explain what would you consider as your biggest achievement and why?
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)?
When to use local filter and when to use global filter?
How to open a universe with out using the Designer ??
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain how we drill up week to month?
What is the difference between the public object&schema object?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
