Advanced Oracle PL/SQL Programming with Packages

Advanced Oracle PL/SQL Programming with PackagesSearch this book
Previous: 8.2 Displaying PLVtab TablesChapter 8
PLVtab: Easy Access to PL/SQL Tables
Next: 8.4 Showing Row Number Toggle
 

8.3 Showing Header Toggle

The PLVtab package is designed to be a generic, low-level utility for working with PL/SQL tables. As such, it needs to be as flexible as possible when it comes to displaying the contents of these tables. I found that I wanted to use PLVtab.display both to:

  1. Dump the contents of a table for debugging and verification purposes; and

  2. Display table contents from within other PL/Vision utilities and packages.

In the first use of PLVtab.display, I could rely on the default header for the table, which is simply:

Contents of Table

since I just wanted to see the results. When I am using PLVtab from within another environment or utility, I need to be able to carefully control the format of the output. In some cases I will want to provide an alternative header, which is done through the parameter list of the display procedure. In other situations, I may want to avoid a header altogether.

The "show header" toggle offers this level of flexibility. The default/initial setting for PLVtab is to display a header with the table. You can turn off the toggle by executing the "no show" procedure as follows:

SQL> exec PLVtab.noshowhdr

In this mode, even if you provide an explicit header in your call to display, that information will be ignored. Only the row information will be displayed.


Previous: 8.2 Displaying PLVtab TablesAdvanced Oracle PL/SQL Programming with PackagesNext: 8.4 Showing Row Number Toggle
8.2 Displaying PLVtab TablesBook Index8.4 Showing Row Number Toggle

The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference