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
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.
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
please send me oracle pl/sql exp resume. and also faqs...
Differentiate between transaction type and transaction source? : oracle accounts receivable
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
What do you mean by hz_ in customer tables? : oracle accounts receivable
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
Explain prerequisites and post activities of oracle database installation
Explain the process of recievables in oracle financials. : oracle accounts receivable
what are basic modules required to implement oracle application in any oraganisation?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
What is the use of lockboxes? : oracle accounts receivable
What is db_recovery_file_dest in oracle? When do you need to set this value?
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?
What is autocashrule set? : oracle accounts receivable