Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Decode and Case?
- 8 Answers
- 47381 Views
- Polaris, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / gurujothi
*CASE can only be used inside the SQL statement where as CASE can be used anywhere even as a parameter of a function or procedure.
*Decode can do equality check only but Case can do more logic comparisons such as <,>etc.,
*The Case will handle NULL differently
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Can anybody tell me what are the tuning problems?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain how we drill up week to month?
what is universe null
Explain difference between zabo and webi?
Can we create universe with no cache??
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 sort of existing documents should business analysts refer to when starting on a new project?
How many universes can be created in a project?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
What are the data types present in bo? What happens if we implement view in the designer and report?
In banking domain how many Fact tables,Dimension table are present?
Explain in detail about type 2(scd),
