SQL> select column_name from dba_tab_columns where table_name='EXPERT_VIEW' AND OWNER='ZDWY';COLUMN_NAME ------------------------------ DEPARTMENT DEPARTMENTNO EXPERTNAME EXPERTNO SPECIALITY SYNOPSIS TYPENUM ZC8 rows selected
简单: select * from user_col_comments where table_name='视图名';
------------------------------
DEPARTMENT
DEPARTMENTNO
EXPERTNAME
EXPERTNO
SPECIALITY
SYNOPSIS
TYPENUM
ZC8 rows selected
select * from user_col_comments where table_name='视图名';