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

Question Posted / anand_82

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

Any body help me...what are challenges did u face in Business object project?

1 Answers

I want to do on drill calculation? Actually My report is like Continent Amount(Global Currency in dollar) ASIA 200 UK 100 On Drill ASIA Country Amount INDIA 5712(120*47.6) SINGAPORE 128(80 * 1.6) On Drill INDIA State Amount DELHI 3712 CHENNAI 2000

2 Answers

what is crystal reports?how to migrate them?

2 Answers IBM,

HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?

2 Answers

in sap bi we have wad, then why we go for sap bo

0 Answers

How to fix the order of Prompts? How to assign the default value in prompt?

2 Answers Mind Tree,

how to make a report avilable to other users?

2 Answers

what is confirm dimension ?