what is diff between Decode and case ? Give some Example?
- 2 Answers
- 6717 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 |
how do u implement dense rank in bo reports?
generally how do we get information for creating universes and reports
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Can master data change???if yes then how it'll change.....please explain with example...... thanx
what types of challenges we are faced in creating web i reports .can you please explain with some examples.
How will solve a loop caused by lookup table without using alias?
how many reports have u created ? explain a few.
0 Answers Bank Of America, TCS,
how to restrict up to three levels in hierarchy when u do drill mode?
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?
Differences between business objects and web intelligence reports?
how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how
Teradata 
