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

how to print multi lay outs,muti currency,muti language in xml publisher

10737


what is pay run id ?

1712


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2096


how do you describe O2C along with tables

2312


what are the balancing segments in AR?

1653






what are the different transaction clauses in AR?

1604


How can a process be deployed in soa?

700


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2469


tell me the scenarios of the independent in reports

2053


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

619


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

665


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

1868


how can i print random rows in plsql table

1942


What do you understand by a set of books?

650


What do you understand by concurrent programs?

619