DICT_COLUMNS

DICT_COLUMNS contains descriptions of columns in data dictionary tables and views.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)		Name of the object that contains the column
COLUMN_NAME	VARCHAR2(30)		Name of the column
COMMENTS	VARCHAR2(4000)		Text comment on the column

Note:

1. Describe column information of data dictionary view DBA_XML_INDEXES;

SELECT * FROM DICT_COLUMNS

WHERE TABLE_NAME = 'DBA_XML_INDEXES';

TABLE_NAME	COLUMN_NAME	COMMENTS
DBA_XML_INDEXES	INDEX_OWNER	Username of the owner of the XML index
DBA_XML_INDEXES	INDEX_NAME	Name of the XML index
DBA_XML_INDEXES	TABLE_OWNER	Username of the owner of the indexed object
DBA_XML_INDEXES	TABLE_NAME	Name of the indexed object
DBA_XML_INDEXES	PATH_TABLE_NAME	Name of the PATH TABLE
DBA_XML_INDEXES	PATHS	Indexed Paths and namespaces

Oracle data dictionary views

Oracle dynamic performance views