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 / zeya.ocp

CASE Expr make u use IF-THEN-ELSE logic in sql statements without to invoke procedure.It complies with ANSI SQL.
DECODE function decode an expr in a way similar to IF-THEN-ELSE logic that is used in various languages.it facilitate conditional inquiries.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1047


what is universe null

2424


What is the difference in creating filters in designer and business objects?

1025


Explain what are the measure objects?

989


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2149


can anybody tell me about complicated object you have created

3222


What would you consider as your biggest achievement and why?

1012


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?

2229


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1182


How to open a universe with out using the Designer ??

7602


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

1029


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

1008


Explain in detail about type 2(scd),

1101


Which versions are used in the bo dashboard work?

1053


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

2255