Procedure in PL/SQL

Syntax:

PROCEDURE name [ARGUMENT LIST]  {IS,AS}

variable declarations

BEGIN

program code

END;

Example:

PROCEDURE swap (A IN OUT NUMBER, B IN OUT NUMBER)

IS

temp NUMBER;

BEGIN

temp :=A;

A :=B;

B :=temp;

END;

Function in PL/SQL

Syntax:

FUNCTION name [ARGUMENT LIST] RETURN data-type {IS,AS}

variable declarations

BEGIN

program code

END;

Example:

FUNCTION check (num in BOOLEAN,

True_num NUMBER,

False_num NUMBER)

RETURN NUMBER IS

BEGIN

IF num THEN  RETURN true_num;

ELSE

RETURN false_num;

END IF;

END;