function can return value ,procedure also return value through
out parameter then what is the difference?
Answers were Sorted based on User's Feedback
Answer / dinakar
Though a procedure returns a value through OUT parameter,
it cannot be used in a SELECT statement. Whereas a function
can be used in a SELECT statement.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / damodharan
function should always return only one value
but procedure may return a value value it may one or more
than one value
Is This Answer Correct ? | 1 Yes | 0 No |
What problem one might face while writing log information to a data-base table in pl/sql?
Which type of cursor is used to execute the dml statement?
How many columns should be in an index?
What are the new features in Oracle 10g. Compared to Oracle 9i?
Explain the advantages and disadvantages of stored procedure?
What is sql rowcount?
Explain what is sql?
what are Dynamic SQL statements?
Which one is better subquery or joins?
What is sql exception?
What is the most important ddl statements in sql are?
What is the purpose of a sql?