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...

Explain the use of decode function

Answer Posted / Rekha

"The DECODE function in Oracle is used to perform conditional logic within SQL queries, similar to an IF-THEN-ELSE statement. It takes up to six arguments: the first argument is the value to be evaluated, and the remaining arguments are a series of conditions and corresponding return values separated by commas. If the first argument matches one of the conditions, the corresponding return value is returned; otherwise, the function returns null."n

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Have you used lexical parameters in reports?

25


Were you involved in any data conversion, which one?

27


Are you familiar with user exits in reports?

27


Any work done in oracle workflow builder. Did you customize or build a new workflow?

23


How many concurrent programs you have customized, can you name some of them?

17