Question Detial
- In Procedure parameter as IN, OUT & INOUT used but for a function always IN parameter works.
- A FUNCTION is always returns a value using the return statement. PROCEDURE may return one or more values through parameters or may not return at all.
- Functions are normally used for computations where as procedures are normally used for executing business logic.
- A Function returns 1 value only. Procedure can return multiple values (max 1024).
- Stored procedure returns always integer value by default zero. Whereas function returns type could be scalar or table or table values.
- Stored procedure is precompiled execution plan where as functions are not.
- A function can call directly by SQL statement like select func_name from dual while procedure cannot.
- Stored procedure has the security and reduces the network traffic and also we can call stored procedure in any no. of applications at a time.
- A Function can be used in the SQL Queries while a procedure cannot be used in SQL queries .that cause a major difference b/w function and procedures.
Hot Questions
How to Get the Size of all Tables in a database in MySQL?