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_6

6. Conditional Compilation

Alex Nuijten¹   and Patrick Barel²

(1)

Oosterhout, Noord-Brabant, The Netherlands

(2)

Almere, Flevoland, The Netherlands

 

Conditional compilation has been available since Oracle 10g. There are countless scenarios in which this can be useful. For example, you can use conditional compilation to check the database (develop, test, production), check the compiler optimization level, include or exclude code depending on the environment, and prepare your code for release on future versions of the database.

Directives

The conditional compilation syntax ...