Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
- 10 Answers
- 50717 Views
- TCS, I also Faced
- E-Mail Answers
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 sql query to find the employee who has Nth maximum salary?
Can we modify approve purchase order?if yes what is navigation?
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
What Are Cross Validation & Adi?
What is supporting issues GL AP and AR?
Could you please let me know the interfaces in OM / FA??
How to clone the database using RMAN back
What do you mean by Oracle MEDIA RECOVERY?
Are These Dff's Flexible?
What is the difference between recovery and restoring of the oracle database?
What is the difference between conversions and interfaces? : oracle accounts receivable
