what is diff between Decode and case ? Give some Example?

Question Posted / anand_82

2 Answers
7204 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is diff between Decode and case ? Give some Example?..

Answer / guest

In case, you can use logic as >, <, <=,>= , whereas in
decode you can only use =.

Is This Answer Correct ?

13 Yes

1 No

what is diff between Decode and case ? Give some Example?..

Answer / jj@hotmail.com

Decode is similiar to an if statement and is Oracle
specific. The Case statement is more universal. The case
statement is more efficient in that it will exit the logic
when it evaluates true. It is also easier to read.

Is This Answer Correct ?

1 Yes

2 No

Post New Answer

More Business Objects Interview Questions

how do u implement dense rank in bo reports?

2 Answers CTS,

What are templates? Explain what you have created?

1 Answers

If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.

2 Answers iFlex, Pfizer,

how to add duplicte rows to the existing report in webi ?

1 Answers HCL,

how u link universes of same functional domain ?

2 Answers Business Intelligence Analytics, IBM,

How can you access your repository with different user profiles?

2 Answers TCS,

What is a loop? How can we overcome?

5 Answers

HOW MANY TABLES ARE EXISTED IN WEBI REPORT?

3 Answers Polaris,

Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?

7 Answers Accenture, Wipro,

what is document design in boxi,have u participate in that

0 Answers Accenture, TCS,

1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?

3 Answers Wipro,

how to make a report avilable to other users?

2 Answers

For more Business Objects Interview Questions Click Here