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

can we use look up type instead of a pofile option?or valueset?is it possible how?

1796


Explain what are the tables of auto invoice?

652


Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

644


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2107


What are the different components of soa suite?

734






List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1806


What is instead of trigger in where we will use?

682


what is pay run id ?

1719


What is the concept of soa governance?

783


How can we import the data into a database using sql * loader?

691


Which oracle apps version you are very confident in?

720


Can you define an erp system?

686


Are you familiar with internet architecture of oracle apps 11i?

640


Can u give the Documentation of Custom.pll in oracle apps

3002


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

625