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

what is global tempory table?

6319


What are the Standard Reports and Forms in HRMS?

1776


What is the concept of soa governance?

776


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

1873


What are the benefits of using soa architecture?

714






please send me forms, xml pulisher questions,answers

1661


How many schemas we have? how many you have used?

1618


What do you understand by a set of books?

652


Explain what are the tables of auto invoice?

650


What is sca and how is it useful?

663


What are the different components of soa suite?

728


What is a flexfield? List out its types.

669


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

651


what are the prerequisites for costing transactions?

2637


what are the different transaction clauses in AR?

1606