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] ...read more

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.

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...read more

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...read more

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 PROCEDUR...read more

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 a...read more

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