Answer Posted / rupesh
function must return value whereas procedure may or maynot
return value
Call to Function can be encounter by using select
statement where as procedure can not be call in select
statement
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
When do we use triggers?
how is myisam table stored? : Sql dba
What is count * in sql?
Can we create a trigger on view?
Why do we need unique key in a table?
Why do we go for stored procedures?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
what are the properties and different types of sub-queries? : Sql dba
What is posting?
what is a stored procedure? : Sql dba
How many times can we commit in a loop?
What is acid property in a database?
Can a view be mutating? If yes, then how?
Why do we need cursor in pl sql?
How does pl sql work?