4.122 ALL_TAB_COLS
ALL_TAB_COLS
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.
This view differs from ALL_TAB_COLUMNS
in that system-generated hidden columns are not filtered out.
Related Views
-
DBA_TAB_COLS
describes the columns of all tables, views, and clusters in the database. -
USER_TAB_COLS
describes the columns of the tables, views, and clusters owned by the current user. This view does not display theOWNER
column.
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 |
|
|
Default value for the column This column may truncate the default value. |
|
|
|
|
Number of distinct values in the column. This column remains for backward compatibility with Oracle7. This information is now in the |
|
|
|
Low value in the column. This column remains for backward compatibility with Oracle7. This information is now in the |
|
|
|
High value in the column. This column remains for backward compatibility with Oracle7. This information is now in the |
|
|
|
If a histogram is available on If a histogram is not available on This column remains for backward compatibility with Oracle7. This information is now in the |
|
|
|
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 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 whether the column is a hidden column ( |
|
|
|
Indicates whether the column is a virtual column ( |
|
|
|
Sequence number of the column in the segment |
|
|
|
Internal sequence number of the column |
|
|
|
Indicates existence/type of histogram:
|
|
|
|
Qualified column name |
|
|
|
Indicates whether the column is a user-generated column ( Invisible columns are hidden columns that are also user- generated columns. |
|
|
|
Indicates whether the column has |
|
|
|
Indicates whether the column has |
|
|
|
Indicates whether the column is a reservable column ( |
|
|
|
Indicates whether the column 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 |
|
|
|
Collation for the column. Only applies to columns with character data types. |
|
|
|
Internal sequence number of a column, for which this virtual column generates a collation key. |
|
|
If a data use case domain is specified for the column, the owner of the data use case domain |
|
|
|
If a data use case domain is specified for the column, the name of the data use case domain |
|
|
|
If a data use case domain is specified for the column, the name of the data use case domain column |
|
|
|
If a data use case domain is specified for the column, the domain association ID |
|
|
|
A value is displayed only for columns of data type If one or more
Possible values for
If a
|
|
|
|
Indicates the number of vectors and their data type in an ONNX model Format: Example: |
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_STATS
package