what is diff between Decode and case ? Give some Example?
Answers were Sorted based on User's Feedback
Answer / guest
In case, you can use logic as >, <, <=,>= , whereas in
decode you can only use =.
| Is This Answer Correct ? | 13 Yes | 1 No |
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 |
Any body help me...what are challenges did u face in Business object project?
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
what is crystal reports?how to migrate them?
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
in sap bi we have wad, then why we go for sap bo
How to fix the order of Prompts? How to assign the default value in prompt?
how to make a report avilable to other users?
what is confirm dimension ?
what is universe null
difference between web intelligence,crystal reports and desktop intelligents
how to create dashboard reports
What are the security level used in BO?