Difference between Decode and Case?
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
Can anybody tell me what are the tuning problems?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain what are the steps to be taken to schedule the report?
What is the difference between datawarehousing and businessintelligence?
What we need to discuss with designer before starting the universe designing.
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What is the difference between business requirement document and use case document.
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
8. How much supervision have you typically received in your previous job?
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 a task that really tested your analytical abilities?
Explain in detail about type 2(scd),
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?