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
What is the difference between absolute and relative div positioning?
Explain which versions are used in the bo dashboard work?
Explain about a task that really tested your analytical abilities?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain when we use aggregate awareness function in designer?
can anybody tell me about complicated object you have created
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What is the difference between user and versatile user?
how to create metric universe ?
Explain the data types present in bo and what happens if we implement view in the designer and report?
what are the day to day activities of BO administrator ?
What is the profile and package?
Explain what are the steps to do to use alerts in bo?
What is report template in b.o?
how many reports have u created ? explain a few.