Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.

Answer Posted / san

can access package elements from out
side of the package only if its declare in package specification

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2390


what is difference between inner join & nested query or subqueries

2482


What is auto invoicing? Explain : oracle accounts receivable

616


What are different types of transactions in ar? : oracle accounts receivable

745


How would you go about increasing the buffer cache hit ratio?

1953






i want to know about the javaBean.what is its purpose and how it can use in Forms.

1833


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

1986


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

6737


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.

1741


where the dff data will be stored

1803


which gives Oracle R12 Financial training in delhi please give me answer its urgent?

1914


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

1907


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

668


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

16360


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

629