Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.

Answer Posted / ezhumalai

A Procedure that performs an action.
A Function that computes a value.

We can call a Function in SELECT Statement.
We can't call a Procedure in SELECT Statement.

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1069


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2291


Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1030


What is an Oracle database Partial Backup?

947


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

2034


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

1802


Are These Dff's Flexible?

941


What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

963


Differentiate between transaction type and transaction source? : oracle accounts receivable

894


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2044


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

2016


What is the difference between oracle media recovery and crash recovery?

933


can we use lexical perameter in oracle plsql if yes how

2102


What are different types of transactions in ar? : oracle accounts receivable

1029


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

920