difference b/w procedures&functions

Answer Posted / abhi choudary

procedure may or may not return a value, but function must return a value.
procedure can not be used in select statement but function can use except one situation whenever select stmt contains dml operation thats time not possible to use

Is This Answer Correct ?    14 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are file in oracle.

1818


tell me the scenarios of the independent in reports

2059


Can you explain the difference between architecture followed in 10g & 11g?

669


what is global tempory table?

6325


how can i print random rows in plsql table

1948






What is oracle soa suite and what are its different components?

656


What is sca and how is it useful?

665


where to define interorganization transaction charges and what are the different options?

1963


What is a flexfield? List out its types.

671


What do you understand by concurrent programs?

627


How can you achieve loose coupling in soa framework?

730


tell me the scenarios of the independent in reports

2124


How do you register report in oracle apps?

638


How to create a purchase order without a requisition?

638


Tell me how to debug the report?

653