Difference between Decode and Case?

Answer Posted / pari

Decode
1.It’s a function
2.can compare only discrete vaules
3.Pl/Sql standards
4.cannot process null

Case
1.It's an Expression
2.can hande range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null

Is This Answer Correct ?    52 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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.

2991


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 ?

1565


What is a fantrap in business objects?

573


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4305


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

583






What is difference between custom hierarchy and report based hierarchy?

544


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

926


how to create reports on screech?

2068


Explain in detail about type 2(scd),

587


Explain the data types present in bo and what happens if we implement view in the designer and report?

555


how many reports have u created ? explain a few.

1655


What is the functional & architectural differences between business objects and web intelligence reports?

549


Explain what are the measure objects?

541


is it possible to export the webi reports to crystal reports?with out using businessview?

1811


Give some information on report bursting?

560