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 is schema in sql?
Explain spool.
what is a view? : Sql dba
what is the difference between primary key and unique key? : Sql dba
What are % type and % rowtype?
what are the properties and different types of sub-queries? : Sql dba
What are functions in sql?
How do I view stored procedures?
How do we accept inputs from user during runtime?
What is varchar example?
What is data profiling in sql?
what are integrity rules?
How do I get sql certification?
What are the various restrictions imposed on view in terms of dml?
Why do we need view in sql?