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

Question Posted / anand_82

2 Answers
7738 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

Difference between Object varification and validation

1 Answers Cognizant,

Hai, Can anyone tell me 'how to use one dataprovider result as an input to another dataprovider?. In BO6.5 there is an option like "select query result". we can use this option in the filter. but the same thing not available in BO XI webi. if any one face this problem , can you please share with me how to do this? Thanks, Narmatha.

3 Answers

Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?

2 Answers TCS,

Aliases and Contexts Which once will give the better performence when resolve the loops?

3 Answers HCL,

I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process

2 Answers Wipro,

How to make alternative rows red and green in WebI Report?

3 Answers Accenture, Mphasis,

who r the users in B.O.XIR2?

2 Answers PCS,

When we use aggregate awareness function in designer?

0 Answers

Difference between b.o 5.1 and 6.1b?