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
Explain about party and customer in ar : oracle accounts receivable
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?
Are These Dff's Flexible?
Why more redos are generated when the oracle database is in begin backup mode?
please send me oracle pl/sql exp resume. and also faqs...
can u give guidance abt packages of plsql
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
as a technical developer in oracle applications which type errors feced in your experience sofar
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.