Database Reference
In-Depth Information
Figure 18.30
Querying
USER_TABLES
and
USER_TAB_COL
UMNS.
The script executed in Figure 18.30 matches all tables and table col-
umns for the currently logged-in user. This gives an example of the power
of metadata views. The script is included in Appendix B.
That covers all we want to cover about tables at present. Chapter 20 cov-
ers constraints and partially returns to the subject of tables. The next chap-
ter looks at views.
18.9
Endnotes
1.
Oracle Performance Tuning for 9
i
and 10
g
(ISBN: 1-55558-305-9)
