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
Explain what are the measure objects?
what is xcelsius architecture?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain about alerts in bos, under what situation we need to use alerts?
Explain the difference between detect alias and detect context?
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??
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
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.
can anybody tell me about complicated object you have created
what will be the contents for a functional requirements specifications
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What is the dense rank?
what is the difference b/w the refresh and buffered data?