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


Please Help Members By Posting Answers For Below Questions

What is meant by cursor in sql?

540


What are stored procedures in mysql?

555


what is a foreign key ? : Sql dba

603


Is join and inner join the same?

534


What is normalisation and its types?

543






What is normalization in a database?

610


List out the acid properties and explain?

560


What is the use of prepared statement?

536


Which is faster count (*) or count 1?

535


Which are sql * plus commands?

535


Can we commit in trigger?

543


Explain aggregate functions are available there in sql?

532


What is trigger in pl sql?

555


What is an exception in pl/sql?

542


Is progress software supports to ( pl/sql )?

523