This appendix summarizes some of the PL/SQL formatting guidelines used throughout this book. While formatting guidelines are not a required part of PL/SQL, they act as best practices that facilitate development of better-quality code, greater readability, and easier maintenance.
PL/SQL, like SQL, is case insensitive. The general guidelines in regard to case are as follows:
Use uppercase for keywords (e.g.,
END LOOP), data types (e.g.,
NUMBER), built-in functions (e.g.,
SUBSTR), and user-defined subroutines (e.g., procedures, functions, packages).