Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
Answer Posted / subhasish dutta
If no write (i.e. insert,delete,update,merge) operation is
made in a function then that function can be used sql
query. if only read operation (i.e. Select) is used in a
function, that can be called from sql query.
Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
Can we modify approve purchase order?if yes what is navigation?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?
How would you go about increasing the buffer cache hit ratio?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
what are basic modules required to implement oracle application in any oraganisation?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Differentiate between transaction type and transaction source? : oracle accounts receivable
default triggers available for reports
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
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
What is Tax Categories?
What is auto invoicing? : oracle accounts receivable
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable