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
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
8. Supporting AP, AR and GL?
Explain the payment term in ar. : oracle accounts receivable
Explain how to close periods in ar. : oracle accounts receivable
types of receipts and detail desription about recipts and tables effected by receipts?
key flexfield structure
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
Difference between transaction type and transaction sources. : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
difference of using cursor for loop and open,fetch,close.which one is better
what are the tools used for oracle 10g in real time.
What is the difference between recovery and restoring of the oracle database?
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.