Difference between Decode and Case?
- 8 Answers
- 45043 Views
- Polaris, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vasu
Decode: using for reporting purpose. and it is implemented
by if stmt.
Ex: select decode(job,'CLERK','executive',job) from emp;
Case : implemented by if & elsif condition. it is using
pl/sql equality conditionality.
Ex : select case job='CLERK' then 'executive' else 'no' end
a from emp;
it is also used for multipul colms & multi conditions.
in above stmt a is reffered alias name.
| Is This Answer Correct ? | 24 Yes | 16 No |
Post New Answer View All Answers
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What is top business?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is the difference between user and versatile user?
Explain about a time when you discovered a more efficient way to do a work task?
How to restrict password to a user while sending a document in .pdf format
Explain the difference between union and group?
Explain which versions are used in the bo dashboard work?
How to schedule the report in b.o?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
what is document design in boxi,have u participate in that
How to open a universe with out using the Designer ??
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
how many reports have u created ? explain a few.
