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 meant by cursor in sql?
What are stored procedures in mysql?
what is a foreign key ? : Sql dba
Is join and inner join the same?
What is normalisation and its types?
What is normalization in a database?
List out the acid properties and explain?
What is the use of prepared statement?
Which is faster count (*) or count 1?
Which are sql * plus commands?
Can we commit in trigger?
Explain aggregate functions are available there in sql?
What is trigger in pl sql?
What is an exception in pl/sql?
Is progress software supports to ( pl/sql )?