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 difference between a FUNCTION, PROCEDURE and
PACKAGE.

Answer Posted / deepak

Note:- procedure may or may not return value.function must
return value
Procedure return one or more value & function return only
single value.
Pakages are groups of functions,procedures,sql blocks
goruped together in a single unit.
Package & packagebody are two different thngs. Variable
defined in packages are global & they can use in anywhere
in packagebody. Variable defined in packagebody have
limited scope. & they can used in defined limit only.

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

A scenario for amount correction & how to use amount correction functionality in AP invoices

2082


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2313


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2877


what are the API of GL,PO,AP

2214


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1006


What is autocashrule set? : oracle accounts receivable

1292


as a technical developer in oracle applications which type errors feced in your experience sofar

2153


What is the difference between oracle media recovery and crash recovery?

1119


types of receipts and detail desription about recipts and tables effected by receipts?

2013


What are different types of receipt reversals ? Explain them : oracle accounts receivable

1195


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2106


What is db_recovery_file_dest in oracle? When do you need to set this value?

1074


What do you mean by hz_ in customer tables? : oracle accounts receivable

1142


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2207


what are the tools used for oracle 10g in real time.

2371