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.

Asked in TCS

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

Top Plsql Developer Interview Questions Asked at TCS

Interview Questions Asked to Plsql Developer at Other Companies

Top Skill-Based Questions for TCS Plsql Developer