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
A scenario for amount correction & how to use amount correction functionality in AP invoices
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
what are the API of GL,PO,AP
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What is autocashrule set? : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar
What is the difference between oracle media recovery and crash recovery?
types of receipts and detail desription about recipts and tables effected by receipts?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
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.
What is db_recovery_file_dest in oracle? When do you need to set this value?
What do you mean by hz_ in customer tables? : oracle accounts receivable
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
what are the tools used for oracle 10g in real time.