Code Library - Oracle Live SQL

Script

The $$PLSQL_UNIT and $$PLSQL_TYPE Conditional Compilation Flags

These pre-defined conditional compilation flags, or ccflags, return the name and type of the program...

CCFLAG,CONDITIONAL COMPILATION

5 143

8.7 years ago Steven Feuerstein

Script

Generate conditional compilation version package for your or any product

Oracle Database has DBMS_DB_VERSION, which can be used with $IF to conditionally include or exclude ...

0 21

2.9 years ago Steven Feuerstein

Script

Examples of Conditional Compilation

Use "$" syntax to affect which lines of code in your source program will be compiled and which ignor...

CONDITIONAL COMPILATION

2 20

9 years ago Steven Feuerstein

Script

Using Conditional Compilation to Deprecate Entities in Some Database Releases

This example shows the deprecation of procedure proc1 if the database release version is greater tha...

LNPLS 12.2.0.1 DEPRECATE PRAGMA

1 13

8 years ago Sarah Hirschfeld (Oracle)

Script

Require Minimum Optimization Level for Program Unit

I have a compute-intensive PL/SQL procedure. If it is not compiled with optimization level set to at...

optimization,conditional compliation

1 9

6.7 years ago Steven Feuerstein

Script

View Post Processed Code (Conditional Compliation)

This script demonstrates use of the DBMS_PREPROCESSOR package to display the "final" source code tha...

conditional compilation

0 4

8.9 years ago Steven Feuerstein

Script

One Program Unit for Multiple Versions of Oracle

This script demonstrates how to use conditional compilation and DBMS_DB_VERSION to take full advanta...

conditional compliation,ifdef,dbms_db_version

0 4

5.7 years ago Steven Feuerstein

Script

Use Conditional Compilation to Test Private Subprograms

There is no way to unit test subprograms defined in the package body. But if you really want to, you...

conditional compilation,test

0 3

6.5 years ago Steven Feuerstein

Script

Show Compilation Parameters

Demonstration of (and resusable procedure) compilation parameters that can be referenced as conditio...

compile,parameters,conditional

0 3

5.6 years ago Steven Feuerstein

Script

A-B Testing with Conditional Compilation

Avoid lots of repetitive code in your A-B testing scripts through the use of conditional compilation...

conditional compilation,test

0 2

6.5 years ago Steven Feuerstein