DBA_COL_COMMENTS

Oracle 11gR1

DBA_COL_COMMENTS displays comments on the columns of all tables and views in the database. Its columns are the same as those in ALL_COL_COMMENTS.

Related Views

· ALL_COL_COMMENTS displays comments on the columns of the tables and views accessible to the current user.

· USER_COL_COMMENTS displays comments on the columns of the tables and views owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
COMMENTS	VARCHAR2(4000)		Comment on the column

Note:

1. Column comments of SYSTEM_PRIVILEGE_MAP:

select * from DBA_COL_COMMENTS where table_name = 'SYSTEM_PRIVILEGE_MAP';

OWNER	TABLE_NAME	COLUMN_NAME	COMMENTS
SYS	SYSTEM_PRIVILEGE_MAP	PRIVILEGE	Numeric privilege type code
SYS	SYSTEM_PRIVILEGE_MAP	NAME	Name of the type of privilege
SYS	SYSTEM_PRIVILEGE_MAP	PROPERTY	Property flag of privilege like not export this privilege, etc

Oracle data dictionary views

Oracle dynamic performance views