update fc_temp_stop set 原房号=replace(原房号,'''','');
select c.housecode, c.房间编号,d.why from
( select housecode,房间编号 from
(select distinct trim(a2.buildingname)||trim(a1.oldcode) as ttt,a1.housecode from fc_house a1,fc_building a2
where a1.buildingcode = a2.buildingcode
and a1.clustercoding = a2.clustercoding) a,(select trim(幢名称)||trim(原房号) as sss,房间编号 from fc_temp_stop) b
where a.ttt(+) = b.sss) c,fc_stopheating d
where c.housecode = d.housecode(+) and d.mon(+)='2011';
select trim(小区编号)||'-'||trim(幢编号)||'-'||trim(单元号)||'-'||trim(楼层)||'-'||trim(门牌号) from fc_temp_stop order by 小区编号,幢名称;
delete from fc_temp_stop;