![]() ![]() ![]() ![]() External PL/SQL libraries are modules that contain named PL/SQL functions and procedures.Here, you will create external libraries and local functions and procedures. You've already create formula columns that used simple PL/SQL expressions to compute their values, and format triggers that used PL/SQL to conditionally determine the formatting of mailing labels. There are a variety of ways to incorporate PL/SQL into your reports.This space is not due to a break it is the result of using a PL/SQL procedure in a format trigger. In the figure above, notice the spacing between records (e.g., between the record for Alexander Khoo and the record for Alexis Bull). In this chapter, you will learn how to use an external PL/SQL library and PL/SQL within a report to modify formatting and calculate the total compensation for each employee. Text description of the illustration plsql_fin.gif Building a PL/SQL Report Figure 37-1 PL/SQL report output ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |