Name
SQL-00: Establish and follow clear rules for how to write SQL in your application.
Synopsis
Never repeat a SQL statement.
Encapsulate all SQL statements behind a procedural interface (usually a package).
Write your code assuming that the underlying data structures will change.
Take advantage of PL/SQL-specific enhancements for SQL.
All these topics—with examples, benefits, and challenges—are explored in the more detailed best practices in this chapter.
Get Oracle PL/SQL Best Practices 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.
