October 1996
Intermediate to advanced
687 pages
16h 41m
English
Content preview from Advanced Oracle PL/SQL Programming with Packages
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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