1) Case Can work with logical operator other than '=' . such as &

Difference between Decode and Case?

Question Posted / suman vyas

8 Answers
47398 Views
Polaris, TCS, Wipro, I also Faced
E-Mail Answers

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

Can Bo generates the Report from the cubical data Explain?

1987

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3406

Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1993

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1165

what will be the contents for a functional requirements specifications

2288

Explain when we use aggregate awareness function in designer?

974

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

998

Can we create universe with no cache??

2443

Explain in detail about type 2(scd),

1047

What we need to discuss with designer before starting the universe designing.

2196

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2078

Explain the data types present in bo and what happens if we implement view in the designer and report?

961

Explain what task is 98% of the required work of a business analyst?

1016

Explain how many universes can be created in a project?

1011

What is the difference between datawarehousing and businessintelligence?

1036