Appendix A PL/SQL Formatting Guide
This appendix summarizes some of the PL/SQL formatting guidelines used throughout this book. Formatting guidelines are not a required part of PL/SQL, but they act as best practices that facilitate code’s quality, readability, and ease of maintenance.
PL/SQL, like SQL, is case-insensitive. The general guidelines here are as follows:
• Use uppercase for keywords (BEGIN, EXCEPTION, END, IF THEN ELSE, LOOP, END LOOP), data types (VARCHAR2, NUMBER), built-in functions (LEAST, SUBSTR), and user-defined subroutines (procedures, functions, packages).
• Use lowercase for variable names as well as column and table names in SQL.
White space (extra lines and spaces) is as important in PL/SQL as it is in ...