|
我有个问题,想请教一下大家。
Select x.code, x.value || ',' || y.value As value
From
Table(pkg_sum_query.vgmtb(15433, 2)) y ,
(Select x.code, x.value || ',' || y.value As value
From (Select Substr(code, 1, 4) || '00000000' As code,
title as value
From DICT_Z120000_S00_Q000001
Where 1 = 1
And Substr(code, 1, 2) = '12'
And code >= '120000000000'
And Substr(code, 5, 8) = '00000000'
And is_ac = 1) x,
Table(pkg_sum_query.vgmtb(15433, 1)) y
WHERE x.code = y.code(+)) x
WHERE x.code = y.code(+)
这是我的sql语句,但是执行的时候,出现“通信通道的文件结束”
请帮我看一下,很急,谢谢 |
|