what is difference between procedure and function

Answer Posted / venky

Function can be use in SQL queries
Procedure can't be used in SQL queries

Function call by an Expression
Procedure call by Statement

The Main diff is DML
Through procedures we can insert,update,delete data from
Table
Through Functions we can't

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you register report in oracle apps?

634


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

1804


What is a flexfield? List out its types.

669


Explain oracle apps architecture.

767


What are the different components you should consider while defining a responsibility in oracle apps?

647






can we use look up type instead of a pofile option?or valueset?is it possible how?

1787


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1657


What are the Standard Reports and Forms in HRMS?

1774


Explain what are the tables of auto invoice?

650


Plz anybody send me Technical specification for AP Interface

2017


Can you define an erp system?

682


pls send me out bound code of supplers,site,bankiformation code pls as soon as

1761


List the types of flexfield?

605


how can i print random rows in plsql table

1942


tell my any difficult situtation you solved in your experience in your company?

1868