What is difference between a PROCEDURE & FUNCTION ?
Answer Posted / surajit pathak
We can use in,inout,out parameters in functions also.
The most important difference is we can use functions in
normal sql queries if it is not containing any out
parameters.
but we cann't use procedures in sql queries....
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is a recursive join sql?
What is query execution plan in sql?
How to combine two stored procedures in sql?
Is a view faster than a stored procedure?
What is the difference between python and sql?
Write an sql query to select all records from the table?
How to get unique records from a table?
how do you know if your mysql server is alive? : Sql dba
Is it possible to create the following trigger: before or after update trigger for each row?
Name three sql operations that perform a sort.
What are records give examples?
What is constant in pl sql?
Which is better stored procedure or query?
Explain foreign key in sql?
what are the types of join and explain each? : Sql dba