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

White space (extra lines and spaces) is as important in PL/SQL as it is in ...

Get Oracle now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.