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

Does pdo prevent sql injection?

520


what are null values? : Sql dba

544


What is consistency?

715


What are the ways on commenting in a pl/sql code?

513


Why query optimization is needed?

519






Which is better trigger or stored procedure?

502


Does sql support programming?

557


Which join is default?

521


What is error ora-01000: maximum open cursors exceeded

604


Can you upgrade sql express to full sql?

518


What is clause in sql?

584


Can a key be both primary and foreign?

510


What is database sql?

541


What is ttitle and btitle?

576


Is there any restriction on the use of union in embedded sql?

679