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
How can we import the data into a database using sql * loader?
tell me the scenarios of the independent in reports
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
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.
What is oracle soa suite and what are its different components?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
Explain what are the tables of auto invoice?
what are the different transaction clauses in AR?
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
What is instead of trigger in where we will use?
What is sca and how is it useful?
Do you know what are user profiles in apps. Any examples you can give?
Tell me how to find the custom directory in front end?
Plz anybody send me Technical specification for AP Interface
What do you understand by soa?