what is the difference between procedure and function
Answer Posted / allabakash
function and procedure both are stored procedures
function contains return clause,where as procedure does not contain return clause
function must return a value, where as procedure may or may not return a value
function can execute as a select statement, where as procedure can execute in anonymous block
we can call function in if statement, we cannot call procedure in if statement
we can call function as a part of expression,where as procedure as a statement
we can pass function as a parameter,where as we cannot pass procedure as a parameter.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the differences between internal requisition and internal sales order?
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.
How is choreography different from orchestration?
List the various types of value set.
List the types of flexfield?
What do you understand by soa and what are the benefits of using this architecture?
How can we import the data into a database using sql * loader?
In hierarchical structure of a database? we have write query from where we should start?
Which oracle apps version you are very confident in?
how to print multi lay outs,muti currency,muti language in xml publisher
please send me forms, xml pulisher questions,answers
what is the difference between request group and request security in oracle apps?
Can we create tables in apps schema?
How do you register report in oracle apps?
What do you understand by concurrent programs?