ORACLE:. h5 l0 M* D& O/ P' X
0 e Q0 Q. k0 W8 m. ~
SELECT vgroup_id,lc_name as col_name, : O. Y2 c9 v/ h) D- {. _
DECODE(LENGTH(field_ind), 1, CONCAT('f000',INITCAP(field_ind)), 2, CONCAT('f00',INITCAP(field_ind)), 3, CONCAT('f0',INITCAP(field_ind)), CONCAT('f',INITCAP(field_ind)) ) AS field_ind
2 c9 o# O1 I9 O2 e: M* tFROM plat_pm_counter_def
4 h4 O) v- Q$ x g9 N8 u6 l7 g1 O0 ?4 E& m7 m8 p
WHERE table_name =''6 r. }% I/ W( R
3 Z* c: h4 [' ?; |/ S# g
其它：
% M" L. \8 W' X% c' t8 c o7 V0 a4 t, N9 J) i0 x% O0 G
SELECT vgroup_id,lc_name as col_name,
6 C9 B* E' b2 I; r4 T0 bcase / s6 V( p( |. Y/ Z3 e6 U
when field_ind |
发表于 2012-8-4 14:06:19
