Difference between Decode and Case?
- 8 Answers
- 44988 Views
- Polaris, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / zeya.ocp
CASE Expr make u use IF-THEN-ELSE logic in sql statements without to invoke procedure.It complies with ANSI SQL.
DECODE function decode an expr in a way similar to IF-THEN-ELSE logic that is used in various languages.it facilitate conditional inquiries.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain how many universes can be created in a project?
What is aggregate table and aggregate fact table ... Any examples of both?
What three things do you consider to be the most important factors for a manager?
how to create reports on screech?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Explain about alerts in bos, under what situation we need to use alerts?
Explain what task is 98% of the required work of a business analyst?
Explain what is the difference between business requirement document and use case document.
What is the difference between business requirement document and use case document.
what is xcelsius architecture?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
in sap bi we have wad, then why we go for sap bo
Explain the difference between detect alias and detect context?
