select TEMP1.FDI_NO,TEMP1.COMP_CODE,TEMP1.DIMENSION1,TEMP1.DIMENSION2,TEMP1.FDI_DATA,TEMP2.FDI_DATA,TEMP3.FDI_DATA from (select FDI_NO,COMP_CODE,DIMENSION1,DIMENSION2,FDI_DATA from (select 'V_TEST_2' as fdi_no from dual) ,( select 'C1340' as COMP_CODE from dual),( select dimvalue_code as DIMENSION1 from tbdimenvaluedefine where dimension_code = 'D_INDPRIOD'),( select dimvalue_code as DIMENSION2 from tbdimenvaluedefine where dimension_code = 'D_CXC_IND'),( select ' ' as FDI_DATA from dual))TEMP1, (select FDI_NO,COMP_CODE,DIMENSION1,DIMENSION2,SUM(FDI_DATA) as FDI_DATA from tbdimendata where FDI_NO='V_TEST_2' and COMP_CODE='C1340' Group By FDI_NO,COMP_CODE,DIMENSION1,DIMENSION2)TEMP2, (select FDI_NO,COMP_CODE,DIMENSION1,DIMENSION2,SUM(FDI_DATA) as FDI_DATA from tbdimendata where FDI_NO='V_TEST_2' and COMP_CODE='C1340' Group By FDI_NO,COMP_CODE,DIMENSION1,DIMENSION2)TEMP3 where TEMP1.FDI_NO = TEMP2.FDI_NO(+) and TEMP1.FDI_NO = TEMP3.FDI_NO(+) and TEMP1.COMP_CODE=TEMP2.COMP_CODE(+) and TEMP1.COMP_CODE= TEMP3.COMP_CODE(+) and TEMP1.DIMENSION1 = TEMP3.DIMENSION1(+) and TEMP1.DIMENSION2 = TEMP2.DIMENSION2(+) and TEMP1.DIMENSION1 = TEMP2.DIMENSION1(+) and TEMP1.DIMENSION2 = TEMP3.DIMENSION2(+)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货