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
Can we modify approve purchase order?if yes what is navigation?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : 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
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What is the mandatory setup in cyclecount ?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What is autocashrule set? : oracle accounts receivable
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
types of receipts and detail desription about recipts and tables effected by receipts?
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.
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What is an Oracle database Partial Backup?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count