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
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
Explain about party and customer in ar : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What Are Cross Validation & Adi?
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.
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What is the disk migration? what is the steps involved in oracle disk migration?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What view would you use to determine free space in a tablespace?
Are These Dff's Flexible?
please send me oracle pl/sql exp resume. and also faqs...
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
how to write customizations in po