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 do you understand by a set of books?
How to create a purchase order without a requisition?
What are file in oracle.
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What do you understand by soa?
How can a process be deployed in soa?
What are the different components of soa suite?
What is count(*) from po_vendors(any table)?
Explain oracle apps architecture.
How do you register report in oracle apps?
Can you explain the difference between architecture followed in 10g & 11g?
In support project one ticket alloted which steps follows manualy tell me ?
tell my any difficult situtation you solved in your experience in your company?
testing tools?