Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Decode and Case?
- 8 Answers
- 47377 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
Can we configure two instances of CMS pointing to two different CMS system databases?
What is the difference between condition & filter?
How to generate the report from excel sheet?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
what are the day to day activities of BO administrator ?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain how to schedule the report in b.o?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain about a task that really tested your analytical abilities?
what is xcelsius architecture?
What is the difference between business requirement document and use case document.
Explain what are the steps to be taken to schedule the report?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
