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.
DBA_TSTZ_TAB_COLS displays information about the columns of all tables in the database, which have columns defined on TIMESTAMP WITH TIME ZONE data types or object types containing attributes of TIMESTAMP WITH TIME ZONE data types. This view does not display the COLUMN_NAME, NESTED , and VIRTUAL_COLUMN columns.
USER_TSTZ_TAB_COLS displays information about the columns of the tables owned by 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. This view does not display the OWNER, COLUMN_NAME, NESTED, or VIRTUAL_COLUMN columns.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the table |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the table |
COLUMN_NAMEFoot 1 |
VARCHAR2(30) |
NOT NULL |
Column name |
QUALIFIED_COL_NAME |
VARCHAR2(4000) |
Qualified column name | |
NESTED |
NUMBER |
Indicates whether the column is a nested table (1) or not (0) |
|
VIRTUAL_COLUMNFootref 1 |
NUMBER |
Identifies whether the column is a virtual column (1) or not (0) |
Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.4)
See Also: