what is the difference between procedure and function

Answer Posted / ramesh babu maldakal

1 Function returns the values but not procedure
2 We can call the functions in select statement but not
procedures
3 In procedures we can perform the DML operations but not
in Functions

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

1824


is it possible to run the interface without using oracle apps?

1717


testing tools?

1970


Tell me how to debug the report?

866


what are the balancing segments in AR?

1855


In hierarchical structure of a database? we have write query from where we should start?

1934


In support project one ticket alloted which steps follows manualy tell me ?

2432


What is the concept of soa governance?

999


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.

2759


What is sca and how is it useful?

848


Can we create tables in apps schema?

849


tell me the scenarios of the independent in reports

2387


In sequence i want to 11 and 15th values how we will write?

1811


please send me forms, xml pulisher questions,answers

1888


How to create a purchase order without a requisition?

862