问题

ORACLE9.2.0.8+linux as 4 运行正常
ORACLE10G+RAC +AIX 运行不正常[@more@]

ORACLE9.2.0.8+linux as 4 运行正常
ORACLE10G+RAC +AIX 运行不正常

Select a.*,
b.* From (Select Substr(Case
When Grouping(f_Ysfzxm_Code1) = 0 And
Nvl(f_Ysfzxm_Code1, 0) <> 0 Then
Space(2 * 6) ||
Fafx_Ljh.Func_Faget_Ysfzxmcode_Mc(a.f_Ysfzxm_Code1)
When Grouping(f_Ysfzhs_Code1) = 0 And
Nvl(f_Ysfzhs_Code1, 0) <> 0 Then
Space(2 * 5) ||
Fafx_Ljh.Func_Faget_Ysfzhscode_Mc(a.f_Ysfzhs_Code1)
When Grouping(f_Ysxm_Code3) = 0 And
Nvl(f_Ysxm_Code3, 0) <> 0 Then
Space(2 * 4) ||
Fafx_Ljh.Func_Faget_Ysxmcode_Mc(a.f_Ysxm_Code3)
When Grouping(f_Ysxm_Code2) = 0 And
Nvl(f_Ysxm_Code2, 0) <> 0 Then
Space(2 * 3) ||
Fafx_Ljh.Func_Faget_Ysxmcode_Mc(a.f_Ysxm_Code2)
When Grouping(f_Ysxm_Code1) = 0 And
Nvl(f_Ysxm_Code1, 0) <> 0 Then
Space(2 * 2) ||
Fafx_Ljh.Func_Faget_Ysxmcode_Mc(a.f_Ysxm_Code1)
When Grouping(f_Ywhd_Code2) = 0 And
Nvl(f_Ywhd_Code2, 0) <> 0 Then
Space(2 * 1) ||
Fafx_Ljh.Func_Faget_Ywhdcode_Mc(a.f_Ywhd_Code2)
Else
'合计'
End,
1,
127) As f_Ysxmbm,
Nvl(f_Ywhd_Code2, 0) As f_Ywhd_Code2,
Nvl(f_Ysxm_Code1, 0) As f_Ysxm_Code1,
Nvl(f_Ysxm_Code2, 0) As f_Ysxm_Code2,
Nvl(f_Ysxm_Code3, 0) As f_Ysxm_Code3,
Nvl(f_Ysfzhs_Code1, 0) As f_Ysfzhs_Code1,
Nvl(f_Ysfzxm_Code1, 0) As f_Ysfzxm_Code1,
Case
When Nvl(a.f_Ywhd_Code2, 0) = 0 Then
Null
Else
Fafx_Ljh.Func_Faget_Ywhdcode_Mc(a.f_Ywhd_Code2) || ''
End || Case
When Nvl(a.f_Ysxm_Code1, 0) = 0 Then
Null
Else
Fafx_Ljh.Func_Faget_Ysxmcode_Mc(a.f_Ysxm_Code1) || ''
End || Case
When Nvl(a.f_Ysxm_Code2, 0) = 0 Then
Null
Else
Fafx_Ljh.Func_Faget_Ysxmcode_Mc(a.f_Ysxm_Code2) || ''
End || Case
When Nvl(a.f_Ysxm_Code3, 0) = 0 Then
Null
Else
Fafx_Ljh.Func_Faget_Ysxmcode_Mc(a.f_Ysxm_Code3) || ''
End || Case
When Nvl(a.f_Ysfzhs_Code1, 0) = 0 Then
Null
Else
Fafx_Ljh.Func_Faget_Ysfzhscode_Mc(a.f_Ysfzhs_Code1) || ''
End || Case
When Nvl(a.f_Ysfzxm_Code1, 0) = 0 Then
Null
Else
Fafx_Ljh.Func_Faget_Ysfzxmcode_Mc(a.f_Ysfzxm_Code1) || ''
End As f_Ysxmqc,
Round(Sum(f_Tbsl), 2) As f_Tbsl,
Round(Sum(f_Tbdj), 2) As f_Tbdj,
Round(Sum(f_Tbje), 2) As f_Tbje,
Round(Sum(f_Gkshsl), 2) As f_Gkshsl,
Round(Sum(f_Gkshdj), 2) As f_Gkshdj,
Round(Sum(f_Gkshje), 2) As f_Gkshje,
Round(Sum(f_Jcshsl), 2) As f_Jcshsl,
Round(Sum(f_Jcshdj), 2) As f_Jcshdj,
Round(Sum(f_Jcshje), 2) As f_Jcshje,
Round(Sum(f_Tbsl_Jd1), 2) As f_Tbsl_Jd1,
Round(Sum(f_Tbsl_Jd2), 2) As f_Tbsl_Jd2,
Round(Sum(f_Tbsl_Jd3), 2) As f_Tbsl_Jd3,
Round(Sum(f_Tbsl_Jd4), 2) As f_Tbsl_Jd4,
Round(Sum(f_Tbje_Jd1), 2) As f_Tbje_Jd1,
Round(Sum(f_Tbje_Jd2), 2) As f_Tbje_Jd2,
Round(Sum(f_Tbje_Jd3), 2) As f_Tbje_Jd3,
Round(Sum(f_Tbje_Jd4), 2) As f_Tbje_Jd4,
Round(Sum(f_Gkshsl_Jd1), 2) As f_Gkshsl_Jd1,
Round(Sum(f_Gkshsl_Jd2), 2) As f_Gkshsl_Jd2,
Round(Sum(f_Gkshsl_Jd3), 2) As f_Gkshsl_Jd3,
Round(Sum(f_Gkshsl_Jd4), 2) As f_Gkshsl_Jd4,
Round(Sum(f_Gkshje_Jd1), 2) As f_Gkshje_Jd1,
Round(Sum(f_Gkshje_Jd2), 2) As f_Gkshje_Jd2,
Round(Sum(f_Gkshje_Jd3), 2) As f_Gkshje_Jd3,
Round(Sum(f_Gkshje_Jd4), 2) As f_Gkshje_Jd4,
Round(Sum(f_Jcshsl_Jd1), 2) As f_Jcshsl_Jd1,
Round(Sum(f_Jcshsl_Jd2), 2) As f_Jcshsl_Jd2,
Round(Sum(f_Jcshsl_Jd3), 2) As f_Jcshsl_Jd3,
Round(Sum(f_Jcshsl_Jd4), 2) As f_Jcshsl_Jd4,
Round(Sum(f_Jcshje_Jd1), 2) As f_Jcshje_Jd1,
Round(Sum(f_Jcshje_Jd2), 2) As f_Jcshje_Jd2,
Round(Sum(f_Jcshje_Jd3), 2) As f_Jcshje_Jd3,
Round(Sum(f_Jcshje_Jd4), 2) As f_Jcshje_Jd4,
Round(Sum(f_Tbsl_Yd1), 2) As f_Tbsl_Yd1,
Round(Sum(f_Tbsl_Yd2), 2) As f_Tbsl_Yd2,
Round(Sum(f_Tbsl_Yd3), 2) As f_Tbsl_Yd3,
Round(Sum(f_Tbsl_Yd4), 2) As f_Tbsl_Yd4,
Round(Sum(f_Tbsl_Yd5), 2) As f_Tbsl_Yd5,
Round(Sum(f_Tbsl_Yd6), 2) As f_Tbsl_Yd6,
Round(Sum(f_Tbsl_Yd7), 2) As f_Tbsl_Yd7,
Round(Sum(f_Tbsl_Yd8), 2) As f_Tbsl_Yd8,
Round(Sum(f_Tbsl_Yd9), 2) As f_Tbsl_Yd9,
Round(Sum(f_Tbsl_Yd10), 2) As f_Tbsl_Yd10,
Round(Sum(f_Tbsl_Yd11), 2) As f_Tbsl_Yd11,
Round(Sum(f_Tbsl_Yd12), 2) As f_Tbsl_Yd12,
Round(Sum(f_Tbje_Yd1), 2) As f_Tbje_Yd1,
Round(Sum(f_Tbje_Yd2), 2) As f_Tbje_Yd2,
Round(Sum(f_Tbje_Yd3), 2) As f_Tbje_Yd3,
Round(Sum(f_Tbje_Yd4), 2) As f_Tbje_Yd4,
Round(Sum(f_Tbje_Yd5), 2) As f_Tbje_Yd5,
Round(Sum(f_Tbje_Yd6), 2) As f_Tbje_Yd6,
Round(Sum(f_Tbje_Yd7), 2) As f_Tbje_Yd7,
Round(Sum(f_Tbje_Yd8), 2) As f_Tbje_Yd8,
Round(Sum(f_Tbje_Yd9), 2) As f_Tbje_Yd9,
Round(Sum(f_Tbje_Yd10), 2) As f_Tbje_Yd10,
Round(Sum(f_Tbje_Yd11), 2) As f_Tbje_Yd11,
Round(Sum(f_Tbje_Yd12), 2) As f_Tbje_Yd12,
Round(Sum(f_Gkshsl_Yd1), 2) As f_Gkshsl_Yd1,
Round(Sum(f_Gkshsl_Yd2), 2) As f_Gkshsl_Yd2,
Round(Sum(f_Gkshsl_Yd3), 2) As f_Gkshsl_Yd3,
Round(Sum(f_Gkshsl_Yd4), 2) As f_Gkshsl_Yd4,
Round(Sum(f_Gkshsl_Yd5), 2) As f_Gkshsl_Yd5,
Round(Sum(f_Gkshsl_Yd6), 2) As f_Gkshsl_Yd6,
Round(Sum(f_Gkshsl_Yd7), 2) As f_Gkshsl_Yd7,
Round(Sum(f_Gkshsl_Yd8), 2) As f_Gkshsl_Yd8,
Round(Sum(f_Gkshsl_Yd9), 2) As f_Gkshsl_Yd9,
Round(Sum(f_Gkshsl_Yd10), 2) As f_Gkshsl_Yd10,
Round(Sum(f_Gkshsl_Yd11), 2) As f_Gkshsl_Yd11,
Round(Sum(f_Gkshsl_Yd12), 2) As f_Gkshsl_Yd12,
Round(Sum(f_Gkshje_Yd1), 2) As f_Gkshje_Yd1,
Round(Sum(f_Gkshje_Yd2), 2) As f_Gkshje_Yd2,
Round(Sum(f_Gkshje_Yd3), 2) As f_Gkshje_Yd3,
Round(Sum(f_Gkshje_Yd4), 2) As f_Gkshje_Yd4,
Round(Sum(f_Gkshje_Yd5), 2) As f_Gkshje_Yd5,
Round(Sum(f_Gkshje_Yd6), 2) As f_Gkshje_Yd6,
Round(Sum(f_Gkshje_Yd7), 2) As f_Gkshje_Yd7,
Round(Sum(f_Gkshje_Yd8), 2) As f_Gkshje_Yd8,
Round(Sum(f_Gkshje_Yd9), 2) As f_Gkshje_Yd9,
Round(Sum(f_Gkshje_Yd10), 2) As f_Gkshje_Yd10,
Round(Sum(f_Gkshje_Yd11), 2) As f_Gkshje_Yd11,
Round(Sum(f_Gkshje_Yd12), 2) As f_Gkshje_Yd12,
Round(Sum(f_Jcshsl_Yd1), 2) As f_Jcshsl_Yd1,
Round(Sum(f_Jcshsl_Yd2), 2) As f_Jcshsl_Yd2,
Round(Sum(f_Jcshsl_Yd3), 2) As f_Jcshsl_Yd3,
Round(Sum(f_Jcshsl_Yd4), 2) As f_Jcshsl_Yd4,
Round(Sum(f_Jcshsl_Yd5), 2) As f_Jcshsl_Yd5,
Round(Sum(f_Jcshsl_Yd6), 2) As f_Jcshsl_Yd6,
Round(Sum(f_Jcshsl_Yd7), 2) As f_Jcshsl_Yd7,
Round(Sum(f_Jcshsl_Yd8), 2) As f_Jcshsl_Yd8,
Round(Sum(f_Jcshsl_Yd9), 2) As f_Jcshsl_Yd9,
Round(Sum(f_Jcshsl_Yd10), 2) As f_Jcshsl_Yd10,
Round(Sum(f_Jcshsl_Yd11), 2) As f_Jcshsl_Yd11,
Round(Sum(f_Jcshsl_Yd12), 2) As f_Jcshsl_Yd12,
Round(Sum(f_Jcshje_Yd1), 2) As f_Jcshje_Yd1,
Round(Sum(f_Jcshje_Yd2), 2) As f_Jcshje_Yd2,
Round(Sum(f_Jcshje_Yd3), 2) As f_Jcshje_Yd3,
Round(Sum(f_Jcshje_Yd4), 2) As f_Jcshje_Yd4,
Round(Sum(f_Jcshje_Yd5), 2) As f_Jcshje_Yd5,
Round(Sum(f_Jcshje_Yd6), 2) As f_Jcshje_Yd6,
Round(Sum(f_Jcshje_Yd7), 2) As f_Jcshje_Yd7,
Round(Sum(f_Jcshje_Yd8), 2) As f_Jcshje_Yd8,
Round(Sum(f_Jcshje_Yd9), 2) As f_Jcshje_Yd9,
Round(Sum(f_Jcshje_Yd10), 2) As f_Jcshje_Yd10,
Round(Sum(f_Jcshje_Yd11), 2) As f_Jcshje_Yd11,
Round(Sum(f_Jcshje_Yd12), 2) As f_Jcshje_Yd12,
Round(Sum(f_Bnysje), 2) As f_Bnysje,
Round(Sum(f_Bnyssl), 2) As f_Bnyssl,
Round(Sum(f_Bnysdj), 2) As f_Bnysdj,
Round(Sum(f_Bnysje_Jd1), 2) As f_Bnysje_Jd1,
Round(Sum(f_Bnysje_Jd2), 2) As f_Bnysje_Jd2,
Round(Sum(f_Bnysje_Jd3), 2) As f_Bnysje_Jd3,
Round(Sum(f_Bnysje_Jd4), 2) As f_Bnysje_Jd4,
Round(Sum(f_Bnyssl_Jd1), 2) As f_Bnyssl_Jd1,
Round(Sum(f_Bnyssl_Jd2), 2) As f_Bnyssl_Jd2,
Round(Sum(f_Bnyssl_Jd3), 2) As f_Bnyssl_Jd3,
Round(Sum(f_Bnyssl_Jd4), 2) As f_Bnyssl_Jd4,
Round(Sum(f_Bnysje_Yd1), 2) As f_Bnysje_Yd1,
Round(Sum(f_Bnysje_Yd2), 2) As f_Bnysje_Yd2,
Round(Sum(f_Bnysje_Yd3), 2) As f_Bnysje_Yd3,
Round(Sum(f_Bnysje_Yd4), 2) As f_Bnysje_Yd4,
Round(Sum(f_Bnysje_Yd5), 2) As f_Bnysje_Yd5,
Round(Sum(f_Bnysje_Yd6), 2) As f_Bnysje_Yd6,
Round(Sum(f_Bnysje_Yd7), 2) As f_Bnysje_Yd7,
Round(Sum(f_Bnysje_Yd8), 2) As f_Bnysje_Yd8,
Round(Sum(f_Bnysje_Yd9), 2) As f_Bnysje_Yd9,
Round(Sum(f_Bnysje_Yd10), 2) As f_Bnysje_Yd10,
Round(Sum(f_Bnysje_Yd11), 2) As f_Bnysje_Yd11,
Round(Sum(f_Bnysje_Yd12), 2) As f_Bnysje_Yd12,
Round(Sum(f_Bnyssl_Yd1), 2) As f_Bnyssl_Yd1,
Round(Sum(f_Bnyssl_Yd2), 2) As f_Bnyssl_Yd2,
Round(Sum(f_Bnyssl_Yd3), 2) As f_Bnyssl_Yd3,
Round(Sum(f_Bnyssl_Yd4), 2) As f_Bnyssl_Yd4,
Round(Sum(f_Bnyssl_Yd5), 2) As f_Bnyssl_Yd5,
Round(Sum(f_Bnyssl_Yd6), 2) As f_Bnyssl_Yd6,
Round(Sum(f_Bnyssl_Yd7), 2) As f_Bnyssl_Yd7,
Round(Sum(f_Bnyssl_Yd8), 2) As f_Bnyssl_Yd8,
Round(Sum(f_Bnyssl_Yd9), 2) As f_Bnyssl_Yd9,
Round(Sum(f_Bnyssl_Yd10), 2) As f_Bnyssl_Yd10,
Round(Sum(f_Bnyssl_Yd11), 2) As f_Bnyssl_Yd11,
Round(Sum(f_Bnyssl_Yd12), 2) As f_Bnyssl_Yd12
From (Select f_Ywhd_Code2,
f_Ysxm_Code1,
f_Ysxm_Code2,
f_Ysxm_Code3,
f_Ysfzhs_Code1,
f_Ysfzxm_Code1,
f_Tbsl,
f_Tbdj,
f_Tbje,
f_Gkshsl,
f_Gkshdj,
f_Gkshje,
f_Jcshsl,
f_Jcshdj,
f_Jcshje,
f_Tbsl_Jd1,
f_Tbsl_Jd2,
f_Tbsl_Jd3,
f_Tbsl_Jd4,
f_Tbje_Jd1,
f_Tbje_Jd2,
f_Tbje_Jd3,
f_Tbje_Jd4,
f_Gkshsl_Jd1,
f_Gkshsl_Jd2,
f_Gkshsl_Jd3,
f_Gkshsl_Jd4,
f_Gkshje_Jd1,
f_Gkshje_Jd2,
f_Gkshje_Jd3,
f_Gkshje_Jd4,
f_Jcshsl_Jd1,
f_Jcshsl_Jd2,
f_Jcshsl_Jd3,
f_Jcshsl_Jd4,
f_Jcshje_Jd1,
f_Jcshje_Jd2,
f_Jcshje_Jd3,
f_Jcshje_Jd4,
f_Tbsl_Yd1,
f_Tbsl_Yd2,
f_Tbsl_Yd3,
f_Tbsl_Yd4,
f_Tbsl_Yd5,
f_Tbsl_Yd6,
f_Tbsl_Yd7,
f_Tbsl_Yd8,
f_Tbsl_Yd9,
f_Tbsl_Yd10,
f_Tbsl_Yd11,
f_Tbsl_Yd12,
f_Tbje_Yd1,
f_Tbje_Yd2,
f_Tbje_Yd3,
f_Tbje_Yd4,
f_Tbje_Yd5,
f_Tbje_Yd6,
f_Tbje_Yd7,
f_Tbje_Yd8,
f_Tbje_Yd9,
f_Tbje_Yd10,
f_Tbje_Yd11,
f_Tbje_Yd12,
f_Gkshsl_Yd1,
f_Gkshsl_Yd2,
f_Gkshsl_Yd3,
f_Gkshsl_Yd4,
f_Gkshsl_Yd5,
f_Gkshsl_Yd6,
f_Gkshsl_Yd7,
f_Gkshsl_Yd8,
f_Gkshsl_Yd9,
f_Gkshsl_Yd10,
f_Gkshsl_Yd11,
f_Gkshsl_Yd12,
f_Gkshje_Yd1,
f_Gkshje_Yd2,
f_Gkshje_Yd3,
f_Gkshje_Yd4,
f_Gkshje_Yd5,
f_Gkshje_Yd6,
f_Gkshje_Yd7,
f_Gkshje_Yd8,
f_Gkshje_Yd9,
f_Gkshje_Yd10,
f_Gkshje_Yd11,
f_Gkshje_Yd12,
f_Jcshsl_Yd1,
f_Jcshsl_Yd2,
f_Jcshsl_Yd3,
f_Jcshsl_Yd4,
f_Jcshsl_Yd5,
f_Jcshsl_Yd6,
f_Jcshsl_Yd7,
f_Jcshsl_Yd8,
f_Jcshsl_Yd9,
f_Jcshsl_Yd10,
f_Jcshsl_Yd11,
f_Jcshsl_Yd12,
f_Jcshje_Yd1,
f_Jcshje_Yd2,
f_Jcshje_Yd3,
f_Jcshje_Yd4,
f_Jcshje_Yd5,
f_Jcshje_Yd6,
f_Jcshje_Yd7,
f_Jcshje_Yd8,
f_Jcshje_Yd9,
f_Jcshje_Yd10,
f_Jcshje_Yd11,
f_Jcshje_Yd12,
f_Bnysje,
f_Bnyssl,
f_Bnysdj,
f_Bnysje_Jd1,
f_Bnysje_Jd2,
f_Bnysje_Jd3,
f_Bnysje_Jd4,
f_Bnyssl_Jd1,
f_Bnyssl_Jd2,
f_Bnyssl_Jd3,
f_Bnyssl_Jd4,
f_Bnysje_Yd1,
f_Bnysje_Yd2,
f_Bnysje_Yd3,
f_Bnysje_Yd4,
f_Bnysje_Yd5,
f_Bnysje_Yd6,
f_Bnysje_Yd7,
f_Bnysje_Yd8,
f_Bnysje_Yd9,
f_Bnysje_Yd10,
f_Bnysje_Yd11,
f_Bnysje_Yd12,
f_Bnyssl_Yd1,
f_Bnyssl_Yd2,
f_Bnyssl_Yd3,
f_Bnyssl_Yd4,
f_Bnyssl_Yd5,
f_Bnyssl_Yd6,
f_Bnyssl_Yd7,
f_Bnyssl_Yd8,
f_Bnyssl_Yd9,
f_Bnyssl_Yd10,
f_Bnyssl_Yd11,
f_Bnyssl_Yd12
From View_Fx_Zhfxb_Ysbz a
Where 1 = 1
And a.f_Bzsfxs = 1
And f_Gkglxnxm = 0
And f_Ysbzzb_Id = 1381
And a.f_Ysnd_Id = 101
And (a.f_Zrzx_Id1 = 6 Or a.f_Zrzx_Id2 = 6 Or
a.f_Zrzx_Id3 = 6 Or a.f_Zrzx_Id4 = 6 Or
a.f_Zrzx_Id5 = 6 Or a.f_Zrzx_Id6 = 6 Or
a.f_Zrzx_Id7 = 6 Or a.f_Zrzx_Id8 = 6 Or
a.f_Zrzx_Id9 = 6 Or a.f_Zrzx_Id10 = 6)) a
Group By Grouping Sets((f_Ywhd_Code2),(f_Ywhd_Code2, f_Ysxm_Code1),(f_Ywhd_Code2, f_Ysxm_Code1, f_Ysxm_Code2),(f_Ywhd_Code2, f_Ysxm_Code1, f_Ysxm_Code2, f_Ysxm_Code3),(f_Ywhd_Code2, f_Ysxm_Code1, f_Ysxm_Code2, f_Ysxm_Code3, f_Ysfzhs_Code1),(f_Ywhd_Code2, f_Ysxm_Code1, f_Ysxm_Code2, f_Ysxm_Code3, f_Ysfzhs_Code1, f_Ysfzxm_Code1),())
Having Case When Grouping(f_Ysfzxm_Code1) = 0 And f_Ysfzxm_Code1 = 0 Then 0 When Grouping(f_Ysfzxm_Code1) = 0 And f_Ysfzxm_Code1 Is Not Null And f_Ysfzxm_Code1 <> 0 Then 1 When Grouping(f_Ysfzhs_Code1) = 0 And f_Ysfzhs_Code1 = 0 Then 0 When Grouping(f_Ysfzhs_Code1) = 0 And f_Ysfzhs_Code1 Is Not Null And f_Ysfzhs_Code1 <> 0 Then 1 When Grouping(f_Ysxm_Code3) = 0 And f_Ysxm_Code3 = 0 Then 0 When Grouping(f_Ysxm_Code3) = 0 And f_Ysxm_Code3 Is Not Null And f_Ysxm_Code3 <> 0 Then 1 When Grouping(f_Ysxm_Code2) = 0 And f_Ysxm_Code2 = 0 Then 0 When Grouping(f_Ysxm_Code2) = 0 And f_Ysxm_Code2 Is Not Null And f_Ysxm_Code2 <> 0 Then 1 When Grouping(f_Ysxm_Code1) = 0 And f_Ysxm_Code1 = 0 Then 0 When Grouping(f_Ysxm_Code1) = 0 And f_Ysxm_Code1 Is Not Null And f_Ysxm_Code1 <> 0 Then 1 When Grouping(f_Ywhd_Code2) = 0 And f_Ywhd_Code2 = 0 Then 0 When Grouping(f_Ywhd_Code2) = 0 And f_Ywhd_Code2 Is Not Null And f_Ywhd_Code2 <> 0 Then 1 Else 1 End = 1
Order By a.f_Ywhd_Code2 Nulls First,
a.f_Ysxm_Code1 Nulls First,
a.f_Ysxm_Code2 Nulls First,
a.f_Ysxm_Code3 Nulls First,
a.f_Ysfzhs_Code1 Nulls First,
a.f_Ysfzxm_Code1 Nulls First) a,
View_Fx_Zhfxb_Ysbz b
Where 1 = 1
And b.f_Bzsfxs = 1
And f_Gkglxnxm = 0
And f_Ysbzzb_Id = 1381
And b.f_Ysnd_Id = 101
And (b.f_Zrzx_Id1 = 6 Or b.f_Zrzx_Id2 = 6 Or b.f_Zrzx_Id3 = 6 Or
b.f_Zrzx_Id4 = 6 Or b.f_Zrzx_Id5 = 6 Or b.f_Zrzx_Id6 = 6 Or
b.f_Zrzx_Id7 = 6 Or b.f_Zrzx_Id8 = 6 Or b.f_Zrzx_Id9 = 6 Or
b.f_Zrzx_Id10 = 6)
And a.f_Ywhd_Code2 = b.f_Ywhd_Code2(+)
And a.f_Ysxm_Code1 = b.f_Ysxm_Code1(+)
And a.f_Ysxm_Code2 = b.f_Ysxm_Code2(+)
And a.f_Ysxm_Code3 = b.f_Ysxm_Code3(+)
And a.f_Ysfzhs_Code1 = b.f_Ysfzhs_Code1(+)
And a.f_Ysfzxm_Code1 = b.f_Ysfzxm_Code1(+)
And b.f_Ysbzzb_Id = 1381
Order By a.f_Ywhd_Code2 Nulls First,
a.f_Ysxm_Code1 Nulls First,
a.f_Ysxm_Code2 Nulls First,
a.f_Ysxm_Code3 Nulls First,
a.f_Ysfzhs_Code1 Nulls First,
a.f_Ysfzxm_Code1 Nulls First

在ORACLE10G RAC上报错误

ORA-03113：通信通道文件结束。

求解！！！

可以确定不是网络问题。

目前已经查过10G比9I的LOG_BUFFER大的多，所以可以排除回滚段问题。

----------------------------------------------------

后来解决的办法是将WHERE条件中的一个逻辑移动到子查询内，运行后结果能正常显示，但至今没找到原因…………总觉得是移动后数据计算量或抽出数据减少的优化起了作用- -！

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/345618/viewspace-1006555/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/345618/viewspace-1006555/