| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
ALL_OBJ_COLATTRS describes object columns and attributes contained in the tables accessible to the current user.
DBA_OBJ_COLATTRS describes object columns and attributes contained in all tables in the database.
USER_OBJ_COLATTRS describes object columns and attributes contained in the tables owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the table | |
TABLE_NAME |
VARCHAR2(30) |
Name of the table containing the object column or attribute | |
COLUMN_NAME |
VARCHAR2(4000) |
Fully qualified name of the object column or attribute | |
SUBSTITUTABLE |
VARCHAR2(15) |
Indicates whether the column is substitutable (Y) or not (N) |
See Also:
|
 Copyright © 2002, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
HTML