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

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3331


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

1963


Explain what are the tables of auto invoice?

871


what are the different transaction clauses in AR?

1829


pls send me out bound code of supplers,site,bankiformation code pls as soon as

2012


What are the different components of soa suite?

924


How to create a purchase order without a requisition?

848


What do you understand by a set of books?

826


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2341


List the various types of value set.

804


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

1925


what are the prerequisites for costing transactions?

2860


Which oracle apps version you are very confident in?

934


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

855


List the types of flexfield?

786