Retrieving Column Comments

user_col_comments view has the comments on your columns:


SQL> SELECT *
  2  FROM user_tab_comments
  3  WHERE table_name = 'EMP';

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
-----------------------------------------------------
EMP                            TABLE
employee stores the information of employees


SQL> SELECT *
  2  FROM user_col_comments
  3  WHERE table_name = 'EMP';

TABLE_NAME                     COLUMN_NAME
------------------------------ ----------------------
COMMENTS
-----------------------------------------------------
EMP                            EMPNO
EMP                            ENAME
ename stores the employee name
EMP                            JOB
EMP                            SAL
EMP                            HIREDATE
EMP                            DEPTNO

6 rows selected.

SQL>
Home »
Oracle »
Table » 

Comment:
  1. Adding a Comment to a Table/Column
  2. Retrieving Table Comments
  3. Retrieving Column Comments
Related: