1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

Difference between Decode and Case?

Question Posted / suman vyas

Answer Posted / suman vyas

1) Case Can work with logical operator other than '=' . such as < , > , = < , >=
where Decode performs an equality check only.

2) Decode can work as function inside SQL only,
where Case can work in Pl/Sql as a substitute of IF-THEN-ELSE.

3) Decode can not process Null , where Case can process Null.

4) Case expects datatype Consistency, Decode Dose not.

5) Decode is a function, where Case is a statement.

hope this will give u satisfied Answer for Difference Between CASE AND DECODE.

Thanks
Suman Vyas

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain when we use aggregate awareness function in designer?

578

What would you consider as your biggest achievement and why?

604

What is the profile and package?

1759

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?

545

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

617




what are the tables used in health care domain project and columns used in report?

4030

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)?

535

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

594

What Is Snow Flake Schema?

662

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1395

What is the difference between absolute and relative div positioning?

574

What are the steps to do to use alerts in bo?

625

what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

9867

Is there any other repository domains rather than universe, security, document?

589

Explain what are the steps to be taken to schedule the report?

631