ch08 03


[Chapter 8] 8.3 Showing Header Toggle Chapter 8PLVtab: Easy Access to PL/SQL Tables 8.3 Showing Header ToggleThe 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:Dump the contents of a table for debugging and verification purposes; andDisplay 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 Tablesince 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.noshowhdrIn 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.8.2 Displaying PLVtab Tables8.4 Showing Row Number Toggle Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Wyszukiwarka

Podobne podstrony:
ch08
ch08
ch08
ch08
ch08
ch08
ch08
CH08
ch08
ch08 (17)
ch08
ch08
ch08
ch08
ch08
ch08
CH08

więcej podobnych podstron