Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
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 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 NESTED
column.
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
or NESTED
columns.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the table |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the table |
QUALIFIED_COL_NAME |
VARCHAR2(4000) |
Qualified column name | |
NESTED |
NUMBER |
Nested table column? |
See Also: