Tutorials
Oracle 10g
Oracle 10g Tutorials -Creating Index-Organized Tables
Oracle 10g Tutorials -Creating Index-Organized Tables - Page 2.
.
The following views allow you to access information about tables
|
View
Description
|
|
These views describe the columns of tables, views, and clusters in the database. Some columns in these views contain statistics that are generated by the
|
These views describe all relational and object tables in the database. Object tables are not specifically discussed in this book.
|
These views display comments for tables and views. Comments are entered using the
|
These views display comments for table and view columns. Comments are entered using the
|
These views list the specific attributes of external tables in the database.
|
These views list the data sources for external tables.
|
These views describe histograms on tables and views.
|
These views provide column statistics and histogram information extracted from the related
|
These views describe tables that have been modified since the last time table statistics were gathered on them. They are not populated immediately, but after a time lapse (usually 3 hours).
|
These views list tables with unused columns, as marked by the
|
These views list tables that have partially completed Example: Displaying Column Information Column information, such as name, datatype, length, precision, scale, and default data values can be listed using one of the views ending with the _COLUMNS suffix. For example, the following query lists all of the default column values for the emp and dept tables: SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, LAST_ANALYZED FROM DBA_TAB_COLUMNS The following is the output from the query:
|