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 |
What is detailed Object
could you please give me the diagram of BO 6.5 Architecture or explain about the tires?
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
it is possible to link two universes of separate functional domain ?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Can any body will explain about sarrogat key? Thanks in advance...........Prakash
What task is 98% of the required work of a business analyst?
What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?
WHAT IS INPUT CONTROL IN BO?
How do you find what type of trap is there by seeing the report?
What is the profile and package?