整理SQL

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;