3.1 Use Compile-Time-Fixed SQL Statement

Use compile-time-fixed SQL statement text unless you cannot.

The term compile-time-fixed SQL statement implies a SQL statement that cannot change at run time and that can be confidently determined by reading the source code. Specifically, a compile-time-fixed SQL statement is a PL/SQL static varchar2 expression. Because the value of a PL/SQL static varchar2 expression cannot change at run time, it can be precomputed at compile time.