Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
Answer Posted / subhasish dutta
If no write (i.e. insert,delete,update,merge) operation is
made in a function then that function can be used sql
query. if only read operation (i.e. Select) is used in a
function, that can be called from sql query.
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
How would you determine who has added a row to a table?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What is the importance of batch source set up in ar? : oracle accounts receivable
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
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.
A scenario for amount correction & how to use amount correction functionality in AP invoices
How would you determine what sessions are connected and what resources they are waiting for?
What is the mandatory setup in cyclecount ?
What is chargeback invoice? How do we create it? : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
what is semphore explian it?
1. What is PO rate variance gain and loss?
as a technical developer in oracle applications which type errors feced in your experience sofar