Chapter 4. Control Structures

Oracle PL/SQL offers a range of constructs that allow you to control the flow of processing, including:

  • For conditional logic: the IF statement

  • For loop processing: FOR, WHILE, and simple loops

  • For branching logic: the GOTO statement

These constructs are relatively straightforward in syntax and usage. There remain, however, several best practices you should take into account when you work with these kinds of statements.

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.