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
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Where in the Oracle directory tree structure are audit traces placed?
as a technical developer in oracle applications which type errors feced in your experience sofar
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What is autocashrule set? : oracle accounts receivable
What is the importance of batch source set up in ar? : oracle accounts receivable
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is Tax Categories?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
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
HOW TO SPOT AHIERARCHY?
what is semphore explian it?
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.