PL/SQL Conditional Compilation use cases and best practice

Source: www.oracle.com
Topic: Oracle Programming

Short Desciption:
PL/SQL conditional compilation 10-November-2005 www.oracle.com/technology/tech/pl_sql/pdf/ Plsql_Conditional_Compilation.pdf NOTE The following is intended to outline our general product direction.

 

Content Inside:
PL/SQL conditional compilation An Oracle White Paper October 2005 PL/SQL conditional compilation 10-November-2005 www.oracle.com/technology/tech/pl_sql/pdf/ Plsql_Conditional_Compilation.pdf NOTE The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracles products remains at the sole discretion of Oracle. PL/SQL conditional compilation 10-November-2005 www.oracle.com/technology/tech/pl_sql/pdf/ Plsql_Conditional_Compilation.pdf PL/SQL conditional compilation CONTENTS Abstract . 1 Introduction 2 PL/SQL conditional compilation constructs 5 The selection directive . 6 The inquiry directive . 9 The error directive 12 Choosing between an inquiry directive and a static package constant . 14 The DBMS_DB_Version package 15 How does PL/SQL conditional compilation work? 17 The PL/SQL compilation pipeline . 17 Using the DBMS_Preprocessor package to see the conditional compilation output . 17 Choosing between the compile-time $if construct and the run-time if construct 20 PL/SQL conditional compilation use cases 23 Latent self-tracing code 23 Latent assertions . 24 Unit testing of subprograms declared only in a package body . 27 Mock objects 34 Comparing competing implementations during prototyping 37 Component based installation . 40 Spanning different releases of Oracle Database with a single source code corpus . 46 Case study: implementing unit testing, assertions, and tracing for a fast cube root body-private helper function 49 Introduction to the case study 49 The design of the Fast_Cbrt() algorithm 50 The requirements for the unit tests 50 Discussion of the PL/S ...

 

 

sql tutorial pdf, plsql conditional compliation, compilation of cases, oracle 9i pl sql advanced tutorial pdf, plsql conditional compilation, compliation of computer ebook download