Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
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 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 |
Indicates whether the column is a nested table (1 ) or not (0 ) |
See Also: