Other Suggestions
For SQL statements embedded in PL/SQL, use the same formatting guidelines to determine how the statements should appear in a block.
Provide a comment header that explains the intent of the block, lists the creation date and author’s name, and have a line for each revision with the author’s name, date, and the description of the revision.
FOR EXAMPLE
The following example shows the aforementioned suggestions. Notice that it also uses a monospaced font (Courier) that makes the formatting easier. Proportional spaced fonts can hide spaces and make lining up clauses difficult. Most text and programming editors by default use a monospace ...
Get Oracle® Web Application Programming for PL/SQL® Developers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
