What is procedure in plsql and it's syntax and difference between procedure and function?

Question

Accepted Answer

A procedure in PL/SQL is a named block of code that can be called and executed multiple times.

Syntax: CREATE [OR REPLACE] PROCEDURE procedure_name [(parameter1 [mode1] datatype1 [, parameter2 [mode2] datatype2]...)] IS
Difference between procedure and function: Procedures do not return a value, while functions return a value.
Procedures are used to perform an action, while functions are used to calculate and return a value.
Procedures can have OUT or IN OUT parameters to pass values back to the caller.
Procedures are called using the CALL statement or as part of a PL/SQL block.

Accepted Answer

Both are sub program.

Procedure may or may not return a value. Function must return a value .

Function called in select statement procedure can't called in select statement.

Accepted Answer

A function would return the returning value/control to the code or calling function. A procedure, on the other hand, would return the control, but would not return any value to the calling function or the code. We cannot use the DML statements in a function, (functions such as Update, Delete, and Insert).

Accepted Answer

A function would return the returning value/control to the code or calling function. A procedure, on the other hand, would return the control, but would not return any value to the calling function or the code. We cannot use the DML statements in a function, (functions such as Update, Delete, and Insert).

Accepted Answer

What is procedure in plsql and it's syntax .

Answer: Procedure are mainly used to do calculations, but you never expect any values on the screen better to go for 'PROCEDURE'.

CREATE OR REPLACE PROCEDURE SP_ANY_NAME (P_PARAMETERS NUMBER,P_PARAMETERS VARCHAR2 ,P_PARAMETERS OUT SYS_REFCURSOR)

AS

ANY VARIABLES IS WE WANT TO DECLARE WE CAN

BEGIN

SET OF STATEMENTS ;

EXCEPTION

END;

Difference between procedure and function?

PROCEDURES cannot be written inside the SQL select statement , FUNCTIONS can be called in the select statement.

PROCEDURES may or may not return values (we can use Return statement inside the procedure but that procedure doesn't act like a return statement in the function ),In FUNCTION we must use return statement.

Accepted Answer

A procedures or function is a set of SQL and PL/SQL statements that perform a specific task. In another way a function and procedure is a named PL/SQL Block. The major difference between a procedure and a function is, a function should return a value but a procedure may or may not return a value.

Syntax :

CREATE [OR REPLACE] PROCEDURE procedure_name ( {IN, OUT, IN OUT} ,…)

IS Declaration section ;

BEGIN

Execution section

EXCEPTION

Exception section

END

Accepted Answer

Both are named PL/SQL Blocks, A procedure that carries out one or more actions. A function returns a value.

What is procedure in plsql and it's syntax and difference between procedure and function?

TCS Plsql Developer interview questions & answers

Popular interview questions of Plsql Developer