17,086
社区成员
发帖
与我相关
我的任务
分享
select
A.COLUMN_NAME,
b.COMMENTS,
decode(a.COLUMN_NAME,'RANK',1,'T_ABAS',2,'T_AS',3,'T_WF',4,'T_EXS',5,'T_EWS',6) disp
from
ALL_TAB_COLUMNS a,user_col_comments b
WHERE
A.TABLE_NAME ='K_KM_PM' and a.COLUMN_NAME=b.COLUMN_NAME and b.TABLE_NAME='K_KM_PM' and
(a.COLUMN_NAME='RANK' or --综合排名
a.COLUMN_NAME='T_ABAS' or --综合得分
a.COLUMN_NAME='T_AS' or --预警率得分
a.COLUMN_NAME='T_WF' or --预警完成率得分
a.COLUMN_NAME='T_EXS' or --超期率得分
a.COLUMN_NAME='T_EWS' --预警指标率得分
)
order by disp
SELECT a.column_name,
b.comments,
(SELECT decode(a.column_name, 'RANK', c.rank, 'T_ABAS', c.t_abas, 'T_AS', c.t_as, 'T_EXS', c.t_exs, c.t_ews) FROM k_km_pm c) VALUE,
decode(a.column_name, 'RANK', 1, 'T_ABAS', 2, 'T_AS', 3, 'T_WF', 4, 'T_EXS', 5, 'T_EWS', 6) disp
FROM all_tab_columns a,
user_col_comments b
WHERE a.table_name = 'K_KM_PM'
AND a.column_name = b.column_name
AND b.table_name = 'K_KM_PM'
AND (a.column_name = 'RANK' OR --综合排名
a.column_name = 'T_ABAS' OR --综合得分
a.column_name = 'T_AS' OR --预警率得分
a.column_name = 'T_WF' OR --预警完成率得分
a.column_name = 'T_EXS' OR --超期率得分
a.column_name = 'T_EWS' --预警指标率得分
)
ORDER BY disp