Advanced Oracle PL/SQL Programming with Packages

Advanced Oracle PL/SQL Programming with PackagesSearch this book
Previous: 8.3 Showing Header ToggleChapter 8
PLVtab: Easy Access to PL/SQL Tables
Next: 8.5 Setting the Display Prefix
 

8.4 Showing Row Number Toggle

The "show row" toggle allows you to specify whether or not you want the row numbers to be displayed along with the contents of the row. The default value for this setting is no row numbers. Turn on the display of row numbers as follows:

SQL> exec PLVtab.showrow

and then when you display the contents of a table, you will see Row N = prefixed to each row value as shown in this output from PLVtab.display:

Row 1505 = ACME
Row 20200 = ArtForms


Previous: 8.3 Showing Header ToggleAdvanced Oracle PL/SQL Programming with PackagesNext: 8.5 Setting the Display Prefix
8.3 Showing Header ToggleBook Index8.5 Setting the Display Prefix

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