select COLUMN_NAME FROM user_col_comments WHERE TABLE_NAME='视图名' select COLUMN_NAME from all_tab_columns WHERE TABLE_NAME='视图名' 不要被名字蒙蔽了,要大胆尝试