| |
 |
|
Oracle Tips by Burleson |
Monitoring Nested Tables
Another table type new to Oracle8 was the
nested table, defined as a table called by reference in another
table and whose reference value appears as a column. Refer back to
the table columns report, shown in Listing 10.7_, and note the
columns named “xxxx_list”(my self-imposed naming convention): each
is an example of a nested table reference column. I suggest that for
ease in recognizing a nested table column, you impose a similar
convention. Each of these “xxxx_list” columns contains a pointer
value that points to a nested table. The DBA_NESTED_TABLES view
provides a convenient place to monitor nested tables. An example of
a report run against the DBA_ NESTED_TABLES view is shown in Source
10.18.
SOURCE 10.18 Example of script to monitor
nested tables.
See Code Depot
www.oracle-script.com |
