What is difference between a PROCEDURE & FUNCTION ?

Answer Posted / anil kumar jampana

sorry, we can use in,inout,out parameters in functions also.
one more diff. we can use functions in normal sql queries
but we cann't use procedures in sql queries....

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is a view faster than a stored procedure?

713


i have some prob lem to tell me about my self in interview first round ...

1887


What is fmtonly in sql?

722


what are wild cards used in database for pattern matching ? : Sql dba

754


What are the different tcl commands in sql?

815






Is sql port 1433 encrypted?

778


What is bulk collect in pl sql?

726


Does user triggers have entry for trigger with compilation errors?

792


Explain the commit statement.

848


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

809


What are the popular database management systems in the it industry?

724


What is memory optimized?

750


Where can I learn sql for free?

700


What is a call statement? Explain with an example.

743


how many values can the set function of mysql take? : Sql dba

719