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 is scalar function?
What is the difference between a primary key and a unique key?
What is java sql package?
what is d diff between grant,commit,rollback n savepoint
what is text? : Sql dba
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Does access use sql?
When to use inner join and left join?
what are the 'mysql' command line options? : Sql dba
Wat is SGA ?
why sql is used as interpreter frequently rather than a compile?
What is dynamic query?