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

Can anybody tell me what are the tuning problems?

1985


any difficulitis have you phase while creating bo reports and how did u solve it

3385


Explain what are the steps to be taken to schedule the report?

1036


What is the difference between datawarehousing and businessintelligence?

1031


What we need to discuss with designer before starting the universe designing.

2189


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2093


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2268


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

979


What is the difference between business requirement document and use case document.

952


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2170


8. How much supervision have you typically received in your previous job?

2201


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

2005


Explain about a task that really tested your analytical abilities?

1187


Explain in detail about type 2(scd),

1041


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

950