USER_TAB_COLS
Purpose
The USER_TAB_COLS view displays all columns of the tables and views accessible to the current user.
This view differs from USER_TABLE_COLUMNS in that hidden columns are not filtered out.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_TAB_COLS
DBA_TAB_COLS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table or view. |
| COLUMN_NAME | VARCHAR2(128) | NO | The name of the column. |
| DATA_TYPE | VARCHAR2(128) | NO | The data type of the column. |
| DATA_TYPE_MOD | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| DATA_TYPE_OWNER | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| DATA_LENGTH | NUMBER | NO | The length of the column in bytes. |
| DATA_PRECISION | NUMBER | NO | The decimal precision for the NUMBER data type and the binary precision for the FLOAT data type. The value is NULL for all other data types. |
| DATA_SCALE | NUMBER | NO | The number of digits on the right of the decimal point in a number. |
| NULLABLE | VARCHAR2(1) | NO | Indicates whether the column can be null. |
| COLUMN_ID | NUMBER | NO | The sequence number of the column. |
| DEFAULT_LENGTH | NUMBER | NO | The default length of the column. |
| DATA_DEFAULT | VARCHAR2(128) | NO | The default value of the column. |
| NUM_DISTINCT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| LOW_VALUE | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| HIGH_VALUE | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| DENSITY | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| NUM_NULLS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| NUM_BUCKETS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| LAST_ANALYZED | DATE | NO | At present, this column is not supported and is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| CHARACTER_SET_NAME | VARCHAR2(44) | NO | At present, this column is not supported and is NULL by default. |
| CHAR_COL_DECL_LENGTH | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| AVG_COL_LEN | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| CHAR_LENGTH | NUMBER | NO | The character length of the column. |
| CHAR_USED | VARCHAR2(1) | NO | Indicates whether the column uses the byte length or the character length. |
| V80_FMT_IMAGE | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| DATA_UPGRADED | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| HIDDEN_COLUMN | VARCHAR2(3) | NO | Indicates whether the column is a hidden column. Valid values: |
| VIRTUAL_COLUMN | VARCHAR2(3) | NO | Indicates whether the column is a virtual column. Valid values: |
| SEGMENT_COLUMN_ID | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| INTERNAL_COLUMN_ID | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| HISTOGRAM | VARCHAR2(15) | NO | At present, this column is not supported and is NULL by default. |
| QUALIFIED_COL_NAME | VARCHAR2(4000) | NO | The qualified column name. |
| USER_GENERATED | VARCHAR2(3) | NO | At present, this column is not supported and is YES by default. |
| DEFAULT_ON_NULL | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| IDENTITY_COLUMN | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| EVALUATION_EDITION | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| UNUSABLE_BEFORE | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| UNUSABLE_BEGINNING | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| COLLATION | VARCHAR2(100) | NO | At present, this column is not supported and is NULL by default. |
| COLLATED_COLUMN_ID | NUMBER | NO | At present, this column is not supported and is NULL by default. |