Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

A. Nuijten, P. BarelModern Oracle Database Programminghttps://doi.org/10.1007/978-1-4842-9166-5_7

7. Iterations and Qualified Expressions

Alex Nuijten¹   and Patrick Barel²

(1)

Oosterhout, Noord-Brabant, The Netherlands

(2)

Almere, Flevoland, The Netherlands

 

Oracle Database has had loop statements since it first introduced PL/SQL into the database. All kinds of loops were possible with a little coding and creating special logic. Many of these “home brew” loop types, like stepped loops and loops with conditional exit points, are now available in standard code.

Iterations

The for loop specifies an iterator and the iteration controls. If necessary, the iteration controls ...