oracle表、字段描述信息

select a.TABLE_NAME,c.comments,a.COLUMN_NAME,b.comments,b.comments,'N',A.DATA_TYPE,B.comments from user_tab_columns a,user_col_comments b,user_tab_comments c where a.table_name in('GWM_DIM_ALARMCATEGORY','GWM_DIM_ALARMPOLTPLT','GWM_DIM_ALARMSPOLICY','GWM_DIM_ALARMSTATUS','
GWM_DIM_ALARMTYPE','GWM_E_CONF_VARIABLES','GWM_E_DIM_GROUPTYPE','GWM_E_DIM_GRP','GWM_E_DIM_GRPMEMB','GWM_E_DIM_OBJECTTYPE','
GWM_E_FACT_SGL2510','GWM_E_FACT_SGL2510GRP','GWM_E_FACT_SGLCONO2','GWM_E_FACT_SGLCONO2GRP','GWM_E_FACT_SGLCOPM25','
GWM_E_FACT_SGLCOPM25GRP','GWM_E_FACT_SGLSO2NO2','GWM_E_FACT_SGLSO2NO2GRP','GWM_E_FACT_SGLSO2PM25','GWM_E_FACT_SGLSO2PM25GRP','
GWM_E_FACT_SGLVARS','GWM_E_FACT_SGLVARSGRP','GWM_E_LEARN_AVG','GWM_E_LEARN_STD','GWM_FACT_ALARMS','GW_DIM_STATION','GW_DIM_STATIONCONFIG','GWM_DIM_ALARMTYPE')

and a.TABLE_NAME = b.table_name and a.COLUMN_NAME = b.column_name
and c.table_name = a.TABLE_NAME
ORDER BY a.TABLE_NAME ASC
;