what is the difference between procedure and function
Answer Posted / srinivas
Function returns only one value, whereas procedure returns
multiple values.
Function can be used in SQL queries whereas we can't use
procedures.
I think in procedures values by reference is not possible.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
In hierarchical structure of a database? we have write query from where we should start?
Which oracle apps version you are very confident in?
Can you differentiate between mediator and osb?
How can we import the data into a database using sql * loader?
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?
where to define interorganization transaction charges and what are the different options?
What are file in oracle.
In sequence i want to 11 and 15th values how we will write?
what is global tempory table?
What do you understand by soa?
What is a flexfield? List out its types.
what are the prerequisites for costing transactions?
what are the balancing segments in AR?
what are the different transaction clauses in AR?
List the various types of value set.