Difference between Decode and Case?
- 8 Answers
- 45106 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
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain what are the measure objects?
What is aggregate table and aggregate fact table ... Any examples of both?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
how many reports have u created ? explain a few.
how to create reports on screech?
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 top business?
When to use local filter and when to use global filter?
Explain is there any other repository domains rather than universe, security, document?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Explain is data mart?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
