采用decode可以实现:
select PROP_ID, decode(PROP_DATATYPE, 1,'varchar(100)', 2,'int', 3,'float', 4,'datetime',null) PROP_DATATYPE, 'not null' PROP_ISNULL,'primary key' PROP_ISMARK,prop_colname
from property where PROP_ISMARK=1
and ws_id=1 and comp_id1
and mb_id= 1
select PROP_ID, decode(PROP_DATATYPE, 1,'varchar(100)', 2,'int', 3,'float', 4,'datetime',null) PROP_DATATYPE, 'not null' PROP_ISNULL,'primary key' PROP_ISMARK,prop_colname
from property where PROP_ISMARK=1
and ws_id=1 and comp_id1
and mb_id= 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货