Database Reference
In-Depth Information
Figure 18.28
Commenting SQL
Code.
The new PURGE command is required to allow clearing the recycle
bin.
The Oracle Database 10
g
SQL Reference Manual states that the
FLASHBACK TABLE command is used to recover a table from the
recycle bin.
This chapter concludes with a short section on database metadata as
directly applicable to this chapter.
18.8
Metadata Views
This section lists metadata views allowing access into the structural details
of tables. Chapter 19 describes the basis and detail of Oracle Database
metadata views.
USER_TABLES
. Table structural definitions.
USER_TAB_COLS
and
USER_TAB_COLUMNS
. Table column
definitions where USER_TAB_COLS includes hidden columns.
