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 b/w procedures&functions

Answers were Sorted based on User's Feedback



difference b/w procedures&functions..

Answer / abhi choudary

procedure may or may not return a value, but function must return a value.
procedure can not be used in select statement but function can use except one situation whenever select stmt contains dml operation thats time not possible to use

Is This Answer Correct ?    14 Yes 0 No

difference b/w procedures&functions..

Answer / raghu

procedure may or may not return a value.
function return a value
procedure will be storeed in db as a compiled object
but funtion will be stored as text what we written

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Oracle Apps Technical Interview Questions

what is latest version in reports

8 Answers  


why r u move in the cus_top only why not move another top

4 Answers  


Can We Create a Synonym On Trigger?

7 Answers   Exeter, Oracle,


What are the files we submit while your program move to testing instance?

4 Answers   Cap Gemini,


What is responsibility?

5 Answers  


LOCKS?

1 Answers  


I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,


In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?

1 Answers   Oracle,


wht is the use of Xml reports over reports6i?

5 Answers  


Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,


please explain open interface import

2 Answers  


What is sca and how is it useful?

0 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)