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

What is the difference between absolute and relative div positioning?

1095


Explain which versions are used in the bo dashboard work?

1125


Explain about a task that really tested your analytical abilities?

1298


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

2346


Explain when we use aggregate awareness function in designer?

1086


can anybody tell me about complicated object you have created

3281


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

1092


What is the difference between user and versatile user?

1140


how to create metric universe ?

2396


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

1071


what are the day to day activities of BO administrator ?

3067


What is the profile and package?

2341


Explain what are the steps to do to use alerts in bo?

1124


What is report template in b.o?

1070


how many reports have u created ? explain a few.

2141