function can return value ,procedure also return value through
out parameter then what is the difference?
Answer Posted / 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 |
Post New Answer View All Answers
When sql appeared?
What is java sql driver?
How do I view tables in sql developer?
How do you update a value in sql?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is difference between left and right outer join?
How do I restart sql?
Mention what is the plv (pl/vision) package offers?
How do sql triggers work?
What does varchar include?
what is the difference between char_length and length? : Sql dba
explain the difference between myisam static and myisam dynamic. : Sql dba
Why do we need pl sql?
What are analytic functions in sql?
What is the usage of sql functions?