Difference between Decode and Case?
Answer Posted / zeya.ocp
CASE Expr make u use IF-THEN-ELSE logic in sql statements without to invoke procedure.It complies with ANSI SQL.
DECODE function decode an expr in a way similar to IF-THEN-ELSE logic that is used in various languages.it facilitate conditional inquiries.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the functional & architectural differences between business objects and web intelligence reports?
how many reports have u created ? explain a few.
How to create Index to the table in the universe designer and how it improves the Query performence
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 how to schedule the report in b.o?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Explain what is the difference between slice and dice and cross tab report?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Explain which versions are used in the bo dashboard work?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Differences between business objects and web intelligence reports?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
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!!!
Explain what are the steps to do to use alerts in bo?