create or replace view sys.dba_col_comments
(owner, table_name, column_name, comments)
as
select u.name, o.name, c.name, co.comment$
from sys."_CURRENT_EDITION_OBJ" o, sys.col$ c, sys.user$ u, sys.com$ co
where o.owner# = u.user#
and o.type# in (2, 4)
and o.obj# = c.obj#
and c.obj# = co.obj#(+)
and c.intcol# = co.col#(+)
and bitand(c.property, 32) = 0 /* not hidden column */;
comment on table SYS.DBA_COL_COMMENTS is 'Comments on columns of all tables and views';
comment on column SYS.DBA_COL_COMMENTS.OWNER is 'Name of the owner of the object';
comment on column SYS.DBA_COL_COMMENTS.TABLE_NAME is 'Name of the object';
comment on column SYS.DBA_COL_COMMENTS.COLUMN_NAME is 'Name of the column';
comment on column SYS.DBA_COL_COMMENTS.COMMENTS is 'Comment on the object';
演示Demo
select * from dba_col_comments t where t.comments like '%班级编号%' order by 1,2,3,4;