what is difference between procedure and function
Answer Posted / monalisa dalbehera
Function always return a single value
Procedure may or may not return a value.
A procedure can return more than one value by using out
parameter.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are triggers and its uses?
Explain what is a column in a table?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
How we can update the view?
What is the usage of distinct keyword?
Is json a nosql?
How does stored procedure reduce network traffic?
How do you define a foreign key?
How do I view tables in sql developer?
What is error ora-12154: tns:could not resolve the connect identifier specified?
When can we use the where clause and the having clause?
What is crud diagram?
What is a record in a database?
What does data normalization mean?
How many databases can sql express handle?