what is the difference between procedure and function

Answer Posted / srinivas

Function returns only one value, whereas procedure returns
multiple values.
Function can be used in SQL queries whereas we can't use
procedures.
I think in procedures values by reference is not possible.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you differentiate between mediator and osb?

625


What do you understand by soa and what are the benefits of using this architecture?

619


Tell me where we find the status of order information?

667


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1798


How do you register report in oracle apps?

626






q)what are the validations in sql*loader

1737


What is the concept of soa governance?

766


what is the differences between internal requisition and internal sales order?

2153


Tell me how to find the custom directory in front end?

658


Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

632


tell me the scenarios of the independent in reports

2106


List the various types of value set.

620


In oracle application how do you debug or trace errors?

639


How to move the one file from one instance to another instance? And your scripts also?

614


What is a value set? List its various types.

650