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
What is auto invoicing? Explain : oracle accounts receivable
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
difference of using cursor for loop and open,fetch,close.which one is better
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
8. Supporting AP, AR and GL?
what are basic modules required to implement oracle application in any oraganisation?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What is mrc and what is its use? : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
What is Restricted Mode of Instance Startup in Oracle?
How would you determine what sessions are connected and what resources they are waiting for?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha