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 universe null

2405


What are the data types present in bo? What happens if we implement view in the designer and report?

1014


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 ?

2039


What is aggregate table and aggregate fact table ... Any examples of both?

1049


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

2229


How many universes can be created in a project?

1021


What is a bo repository?

1033


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

977


what are the tables used in health care domain project and columns used in report?

4491


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

995


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1026


in sap bi we have wad, then why we go for sap bo

3364


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1088


how get the grand total in master-detail report?

2218


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

1015