3.126 ALL_TSTZ_TAB_COLS
ALL_TSTZ_TAB_COLS
displays information about the columns of the tables accessible to the current user, which have columns defined on TIMESTAMP WITH TIME ZONE
data types or object types containing attributes of TIMESTAMP WITH TIME ZONE
data types.
Related Views
-
DBA_TSTZ_TAB_COLS
displays information about the columns of all tables in the database, which have columns defined onTIMESTAMP WITH TIME ZONE
data types or object types containing attributes ofTIMESTAMP WITH TIME ZONE
data types. This view does not display theCOLUMN_NAME
,NESTED
, andVIRTUAL_COLUMN
columns. -
USER_TSTZ_TAB_COLS
displays information about the columns of the tables owned by the current user, which have columns defined onTIMESTAMP WITH TIME ZONE
data types or object types containing attributes ofTIMESTAMP WITH TIME ZONE
data types. This view does not display theOWNER
,COLUMN_NAME
,NESTED
, andVIRTUAL_COLUMN
columns.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the table |
|
|
|
Name of the table |
|
|
|
Column name |
|
|
|
Qualified column name |
|
|
|
Indicates whether the column is a nested table ( |
|
|
|
Indicates whether the column is a virtual column ( |
|
|
|
Indicates whether the column is a scalar column ( |
|
|
|
Indicates whether the column is an unused column ( |
See Also: