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


Please Help Members By Posting Answers For Below Questions

Explain about party and customer in ar : oracle accounts receivable

972


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?

2201


Are These Dff's Flexible?

938


Why more redos are generated when the oracle database is in begin backup mode?

895


please send me oracle pl/sql exp resume. and also faqs...

2299


can u give guidance abt packages of plsql

1890


IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2029


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2634


as a technical developer in oracle applications which type errors feced in your experience sofar

2126


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1053


Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1555


Explain the process of recievables in oracle financials. : oracle accounts receivable

909


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1939


hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2017


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7218