Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
- 10 Answers
- 54673 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 technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
What is the difference between oracle media recovery and crash recovery?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What is the sql query to find the employee who has Nth maximum salary?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
What is Restricted Mode of Instance Startup in Oracle?
A scenario for amount correction & how to use amount correction functionality in AP invoices
Why more redos are generated when the oracle database is in begin backup mode?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
What are different types of receipt reversals ? Explain them : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What is the disk migration? what is the steps involved in oracle disk migration?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is auto invoicing? Explain : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar
