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


Please Help Members By Posting Answers For Below Questions

What is auto invoicing? Explain : oracle accounts receivable

811


Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1031


Difference between transaction type and transaction sources. : oracle accounts receivable

781


difference of using cursor for loop and open,fetch,close.which one is better

1487


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4183


8. Supporting AP, AR and GL?

2068


what are basic modules required to implement oracle application in any oraganisation?

1960


what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

1974


What is mrc and what is its use? : oracle accounts receivable

829


as a technical developer in oracle applications which type errors feced in your experience sofar

2111


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

910


What is Restricted Mode of Instance Startup in Oracle?

923


How would you determine what sessions are connected and what resources they are waiting for?

1848


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

869


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

2200