what is the difference between procedure and function

Answer Posted / venki_discussions

procedure perform one or more actions it may return or may
not return values if u want to return procedure ill return
multiple values.we can use procedures in oracel apps also

function perform one or more actions and it must return any
value multiple values will not return function.functions
we cant use in oracle apps.we can perform functions on SQL
prompt itslef.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a flexfield? List out its types.

668


Which oracle apps version you are very confident in?

707


What does appl_top directory contain?

647


how do you describe O2C along with tables

2310


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

2996






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

2129


what is pay run id ?

1711


Can you explain the difference between architecture followed in 10g & 11g?

660


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

675


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

1570


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.

2467


Do you know where we can check the status of po?

638


q)what are the validations in sql*loader

1743


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

1888


List the various types of value set.

623