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 the merge dimension?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
What is maximum number of promts we can give in a BO report?
Explain about alerts in bos, under what situation we need to use alerts?
Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both
what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?
Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please
what are the day to day activities of BO administrator ?
How would you format some text using css to be verdana and bold?
What are the steps to taken care to improve the Report performance?
What is casual dimension?
Report have 10000 records,how to restrict the end user to 1000 Records?