ORACLE中和一般数据库条件判断的区别
ORACLE:SELECTvgroup_id,lc_name as col_name,
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
FROM plat_pm_counter_def
WHERE table_name =''
其它:
SELECTvgroup_id,lc_name as col_name,
case
when field_ind
页:
[1]