Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Difference between Decode and Case?

Answer Posted / gurujothi

*CASE can only be used inside the SQL statement where as CASE can be used anywhere even as a parameter of a function or procedure.
*Decode can do equality check only but Case can do more logic comparisons such as <,>etc.,
*The Case will handle NULL differently

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain which versions are used in the bo dashboard work?

1092


Explain what task is 98% of the required work of a business analyst?

1103


What is a fantrap in business objects?

1170


What is the difference between absolute and relative div positioning?

1048


Explain difference between zabo and webi?

1099


What are the join problems comes appart from loop,chasm & fan Traps

2132


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

1029


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.

3477


Explain how we drill up week to month?

1092


how to prepare the documentation in business objects and where to get the requirement?

2222


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10893


Explain when to use local filter and when to use global filter?

1360


What are all difference between business objects 6.5 and xi r2?

1031


Differences between business objects and web intelligence reports?

1223


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

2121