ALL_TAB_COLUMNS
describes the columns of the tables, views, and clusters accessible to the current user. To gather statistics for this view, use the DBMS_STATS
package.
Related Views
DBA_TAB_COLUMNS
describes the columns of all tables, views, and clusters in the database.
USER_TAB_COLUMNS
describes the columns of the tables, views, and clusters owned by the current user. This view does not display the OWNER
column.
This view filters out system-generated hidden columns and invisible columns, which are user-generated hidden columns. The ALL_TAB_COLS
view does not filter out hidden columns and invisible columns.
See Also:
For more information about invisible columns:
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 column1 |
|
|
|
High value in the column1 |
|
|
|
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 gathered for the table as a whole (global statistics) ( |
|
|
|
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 datatypes:
|
|
|
|
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 |
|
|
|
Indicates whether this is an identity column ( |
|
|
|
Name of the edition in which editioned objects referenced in an expression column are resolved |
|
|
|
Name of the oldest edition in which the column is usable |
|
|
|
Name of the oldest edition in which the column becomes perpetually unusable |
See Also:
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_STATS
package
These columns remain for backward compatibility with Oracle7. This information is now in the {TAB
|PART
}_COL_STATISTICS
views.