3,490
社区成员
发帖
与我相关
我的任务
分享
select decode(ys.acccodj_0,1,ACC_0,2,ACC_1,3,ACC_2,4,ACC_3,
5,ACC_4,6,ACC_5,7,ACC_6,8,ACC_7,
9,ACC_8,10,ACC_9,11,ACC_10,12,ACC_11,
13,ACC_12,14,ACC_13,15,ACC_14,16,ACC_15,
17,ACC_16,18,ACC_17,19,ACC_18,20,ACC_19,
21,ACC_20,22,ACC_21,23,ACC_22,24,ACC_23,
25,ACC_24,26,ACC_25,27,ACC_26,28,ACC_27,
29,ACC_28,30,ACC_29,31,ACC_30,32,ACC_31,
33,ACC_32,34,ACC_33,35,ACC_34,36,ACC_35,
37,ACC_36,38,ACC_37,39,ACC_38,40,ACC_39,
41,ACC_40,42,ACC_41,43,ACC_42,44,ACC_43,
45,ACC_44,46,ACC_45,47,ACC_46,48,ACC_47,
49,ACC_48,50,ACC_49,51,ACC_50,52,ACC_51,
53,ACC_52,54,ACC_53,55,ACC_54,56,ACC_55,
57,ACC_56,58,ACC_57,59,ACC_58,60,ACC_59,
61,ACC_60,62,ACC_61,63,ACC_62,64,ACC_63,
65,ACC_64,66,ACC_65,67,ACC_66,68,ACC_67,
69,ACC_68,70,ACC_69,71,ACC_70,72,ACC_71,
73,ACC_72,74,ACC_73,75,ACC_74,76,ACC_75,
77,ACC_76,78,ACC_77,79,ACC_78,80,ACC_79,
81,ACC_80,82,ACC_81,83,ACC_82,84,ACC_83,
85,ACC_84,86,ACC_85,87,ACC_86,88,ACC_87,
89,ACC_88,90,ACC_89,91,ACC_90,92,ACC_91,
93,ACC_92,94,ACC_93,95,ACC_94,96,ACC_95,
97,ACC_96,98,ACC_97,99,ACC_98,' ') accj ,decode(ys.acccodd_0,1,ACC_0,2,ACC_1,3,ACC_2,4,ACC_3,
5,ACC_4,6,ACC_5,7,ACC_6,8,ACC_7,
9,ACC_8,10,ACC_9,11,ACC_10,12,ACC_11,
13,ACC_12,14,ACC_13,15,ACC_14,16,ACC_15,
17,ACC_16,18,ACC_17,19,ACC_18,20,ACC_19,
21,ACC_20,22,ACC_21,23,ACC_22,24,ACC_23,
25,ACC_24,26,ACC_25,27,ACC_26,28,ACC_27,
29,ACC_28,30,ACC_29,31,ACC_30,32,ACC_31,
33,ACC_32,34,ACC_33,35,ACC_34,36,ACC_35,
37,ACC_36,38,ACC_37,39,ACC_38,40,ACC_39,
41,ACC_40,42,ACC_41,43,ACC_42,44,ACC_43,
45,ACC_44,46,ACC_45,47,ACC_46,48,ACC_47,
49,ACC_48,50,ACC_49,51,ACC_50,52,ACC_51,
53,ACC_52,54,ACC_53,55,ACC_54,56,ACC_55,
57,ACC_56,58,ACC_57,59,ACC_58,60,ACC_59,
61,ACC_60,62,ACC_61,63,ACC_62,64,ACC_63,
65,ACC_64,66,ACC_65,67,ACC_66,68,ACC_67,
69,ACC_68,70,ACC_69,71,ACC_70,72,ACC_71,
73,ACC_72,74,ACC_73,75,ACC_74,76,ACC_75,
77,ACC_76,78,ACC_77,79,ACC_78,80,ACC_79,
81,ACC_80,82,ACC_81,83,ACC_82,84,ACC_83,
85,ACC_84,86,ACC_85,87,ACC_86,88,ACC_87,
89,ACC_88,90,ACC_89,91,ACC_90,92,ACC_91,
93,ACC_92,94,ACC_93,95,ACC_94,96,ACC_95,
97,ACC_96,98,ACC_97,99,ACC_98,' ') accd ,
select acccodj_0,acccodd_0 ,"字段ACC_" || acccodj_0 || "的值" as xxx