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: