6.32 DBA_TAB_COLUMNS
DBA_TAB_COLUMNS
describes the columns of all tables, views, and clusters in the database.
Its columns (except for SENSITIVE_COLUMN
) are the same as those in ALL_TAB_COLUMNS
.
To gather statistics for this view, use the DBMS_STATS
package.
This view filters out system-generated hidden columns. The DBA_TAB_COLS
view does not filter out system-generated hidden columns.
Columns marked with an asterisk (*) in the table below remain for backward compatibility with Oracle7. This information is now in the [TAB|PART]_COL_STATISTICS
views.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the table, view, or cluster |
|
|
|
Name of the table, view, or cluster |
|
|
|
Column name |
|
|
|
Data type of the column |
|
|
|
Data type modifier of the column |
|
|
|
Owner of the data type of the column |
|
|
|
Length of the column (in bytes) |
|
|
|
Decimal precision for |
|
|
|
Digits to the right of the decimal point in a number |
|
|
|
Indicates whether a column allows NULLs. The value is |
|
|
|
Sequence number of the column as created |
|
|
|
Length of the default value for the column |
|
|
|
Default value for the column |
|
|
|
Number of distinct values in the column |
|
|
|
Low value in the column |
|
|
|
High value in the column |
|
|
|
If a histogram is available on If a histogram is not available on |
|
|
|
Number of NULLs in the column |
|
|
|
Number of buckets in the histogram for the column Note: The number of buckets in a histogram is specified in the |
|
|
|
Date on which this column was most recently analyzed |
|
|
|
Sample size used in analyzing this column |
|
|
|
Name of the character set:
|
|
|
|
Declaration length of the character type column |
|
|
|
|
|
|
|
Indicates whether statistics were entered directly by the user ( |
|
|
|
Average length of the column (in bytes) |
|
|
|
Displays the length of the column in characters. This value only applies to the following data types:
|
|
|
|
Indicates that the column uses
|
|
|
|
Indicates whether the column data is in release 8.0 image format ( |
|
|
|
Indicates whether the column data has been upgraded to the latest type version format ( |
|
|
|
Indicates existence/type of histogram:
|
|
|
|
Indicates whether the column has DEFAULT ON NULL semantics ( |
|
|
|
Indicates whether this is an identity column ( |
|
|
|
Indicates whether this is a sensitive column ( |
|
|
|
Name of the edition in which editioned objects referenced in an expression column are resolved |
|
|
|
Name of the oldest edition in which the index may be used as part of a query plan |
|
|
|
Name of the edition for which the index may not be used as part of a query plan in this edition or any of its descendants |
|
|
|
Collation for the column. Only applies to columns with character data types. |
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_STATS
package