Basic PL/SQL: Part 2 (Function, Produre and Trigger)

Syntax to create Function:
CREATE OR REPLACE FUNCTION [function name]([parameter] [IN|OUT] [data type])

RETURN [data type]
AS
[declare];


BEGIN

[do something];

RETURN [something];

END;

/

Syntax to create Procedure:
CREATE OR REPLACE PROCEDURE [procedure name]([parameter] [IN|OUT] [data type]) AS

[declaration];

BEGIN

[do something];

END;

/

Syntax to create Trigger:
CREATE OR REPLACE TRIGGER [trigger name]

[AFTER | BEFORE] [INSERT OR UPDATE OR DELETE] ON [table name]

REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW
BEGIN
IF INSERTING THEN
[do something];

END IF;

IF UPDATING THEN
[do something];

END IF;

IF DELETING THEN
[do something];

END IF;
END;
/