Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
Answer Posted / suresh
Function must return one value
Procedure may or may not return one or more values.
Can call functions in Sql statements
we can't call a procedure in sql statements
Functions can not return images
procedure returns images
| Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Is there any link between pr form(purchse requisition)and po form(purchase order)
Why more redos are generated when the oracle database is in begin backup mode?
as a technical developer in oracle applications which type errors feced in your experience sofar
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
Difference between negative and positive adjustments : oracle accounts receivable
Explain the use of table functions.
Give two methods you could use to determine what DDL changes have been made.