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 is pay run id ?

1710


How do you register report in oracle apps?

632


What do you understand by concurrent programs?

619


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2128


Explain oracle apps architecture.

767






Do you know what are user profiles in apps. Any examples you can give?

663


How to move the one file from one instance to another instance? And your scripts also?

615


Can you define an erp system?

681


Do you know what is applysys in oracle application database schema, what is apps?

674


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2092


What are the Standard Reports and Forms in HRMS?

1772


What is a value set? List its various types.

650


List the various types of value set.

622


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

1573


Can we create tables in apps schema?

622