PL/SQL functions and/or procedures

Deterministic and pipelined and polymorphic table (PTF) functions.

Enabling PL/SQL functions for parallel execution.

Oeverhead when using functions in SQL.

SQL macros

A select statement in a PL/SQL function which is executed from a select statement, does not throw a ORA-01403: no data found error.

Unlike variables, a parameter that is declared to be a varchar2 does not need to have a maximum length specification, see the error message PLS-00215: String length constraints must be in range (1 .. 32767).