Stored procedures can be written in SQL PL, but not in the PL/SQL dialect

The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database

There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures

Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

INSERT INTO t1 VALUES (100)

INSERT INTO t1 (c1, c2) VALUES (100)

INSERT INTO t1 (c1, c3) VALUES (‘100’, ‘100.00’)

INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101)

Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements

Triggers can be used to perform data manipulation operations against complex views

Triggers can only be used to execute logic before or after appropriate SQL statements

Only one trigger for a particular event and activation time can be created for a particular table