Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.

Answer Posted / karunakar remala

Procedure and functions contains scope with in package
only..but coming to it contains scope out side of the
package also.i.e we can access package elements from out
side of the package also.

Is This Answer Correct ?    11 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

1733


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

3981


please send me oracle pl/sql exp resume. and also faqs...

2034


Differentiate between transaction type and transaction source? : oracle accounts receivable

671


now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

1791






What do you mean by hz_ in customer tables? : oracle accounts receivable

635


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

1953


Explain prerequisites and post activities of oracle database installation

1612


Explain the process of recievables in oracle financials. : oracle accounts receivable

654


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

1696


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2049


What is the use of lockboxes? : oracle accounts receivable

649


What is db_recovery_file_dest in oracle? When do you need to set this value?

644


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2352


What is autocashrule set? : oracle accounts receivable

723