Functions and Procedures and differences between them

Question

Accepted Answer

Functions and procedures are both stored database objects used to perform specific tasks in SQL.

Functions return a value while procedures do not.
Functions can be used in SQL statements, whereas procedures cannot.
Functions can have input parameters and return a single value, while procedures can have input and output parameters.
Functions are typically used for calculations or data manipulation, while procedures are used for executing a series of SQL statements.
Examples of functions include SUM, AVG, and CONCAT, while examples of procedures include INSERT, UPDATE, and DELETE.

Accepted Answer

1) Procedure perform an action

Function compute value and simple fetch

2) Header Won't contain Return clause

Function Must contain Return Clause

3) Procedure May or May not Return any value

Function Must return One value

4) Exec or Directly mention it in sub program

Part of select statement or Variable

Accepted Answer

1) Procedure is performed task

Function is use performed calculation.

2) procedure main are main not return value.

Function is return value

Top BNP Paribas SQL Developer interview questions & answers