what is diff between Decode and case ? Give some Example?
- 2 Answers
- 7128 Views
- I also Faced
- E-Mail Answers
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 |
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
When is the Repository created?
how can i add two different reports in the same document?
What Is The Difference Between Oltp And Olap?
Can we Save (save as) WEBI Doc as DESKI?
How can we use multiple data providers in a single report in business objects?
What is the difference between slice and dice and cross tab report?
1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?
Is there any other repository domains rather than universe, security, document?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What is the profile and package?
Approximatly how many enduser can use the each bo project?
Teradata 
