Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.

Answer Posted / rashmipriya

procedure call is pl/sql statement by itself.

function call is part of an expression.

Is This Answer Correct ?    16 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain prerequisites and post activities of oracle database installation

1616


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

738


Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

726


what are the API of GL,PO,AP

1774


What is auto invoicing? Explain : oracle accounts receivable

616






i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

1768


QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

1645


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

656


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

733


what is difference between inner join & nested query or subqueries

2482


can we use lexical perameter in oracle plsql if yes how

1825


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1704


How many segment are present in Oracle Manufacturing

1807


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

1846


Explain the use of table functions.

1796