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 are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
8. Supporting AP, AR and GL?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
what are the tools used for oracle 10g in real time.
Explain the payment term in ar. : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
What Are Cross Validation & Adi?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
How do you create a credit note against an invoice? : oracle accounts receivable
what are the API of GL,PO,AP
How many segment are present in Oracle Manufacturing
What is supporting issues GL AP and AR?