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

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

1846


How would you determine who has added a row to a table?

1792


How would you determine what sessions are connected and what resources they are waiting for?

1614


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

738


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

1544






key flexfield structure

1601


Explain the payment term in ar. : oracle accounts receivable

617


What is supporting issues GL AP and AR?

1987


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

1587


1. What is PO rate variance gain and loss?

2312


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

624


What is the sql query to find the employee who has Nth maximum salary?

4287


how to write customizations in po

1197


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2359


What is the use of lockboxes? : oracle accounts receivable

655