oracle sql语句高手请进,为什么这句话无法执行,好像上了锁,来解一下吧!
这句话无法执行,好像上了锁,两个子查询访问相同(大多数)的几个表,分别执行没问题,合在一块,就不行了!
select aa.fahuor,aa.chepihao,aa.price - bb.price dd
from
(select f.chepihao chepihao,f.fahuor fahuor,round((a.value_s+a.value_x)*a.bijia*b.bijia*c.bijia*d.bijia*e.bijia_a*e.bijia_kp*decode(sign(e.qnet_zuidi-f.qnet),1,0,1)/2,1) price
from meijia_bijia a,meijia_bijia b,meijia_bijia c,meijia_bijia d,meijia_hetong e,tcepihao f
where a.bijiacont='Qnet.ar' and b.bijiacont='Vdaf' and c.bijiacont='Std' and d.bijiacont='Aar'
and e.kuangming=f.kuangming
and decode(sign(f.qnet-qnet_zuigao),-1,f.qnet,0,qnet_zuigao,1,qnet_zuigao)>a.value_s and decode(sign(f.qnet-qnet_zuigao),-1,f.qnet,0,qnet_zuigao,1,qnet_zuigao)<=a.value_x and f.Vdaf>b.value_s and f.Vdaf<=b.value_x
and f.stad>c.value_s and f.stad<=c.value_x and f.aar>d.value_s and f.aar<=d.value_x
and e.kuangming='0107'
and to_char(f.fahuor,'MM/YY')='06/01' WITH READ ONLY ) aa ,
(select f.chepihao chepihao,f.fahuor fahuor,round((a.value_s+a.value_x)*a.bijia*b.bijia*c.bijia*d.bijia*e.bijia_a*e.bijia_kp*decode(sign(e.qnet_zuidi-f.qnet),1,0,1)/2,1) price
from meijia_bijia a,meijia_bijia b,meijia_bijia c,meijia_bijia d,meijia_hetong e,schepihao f
where a.bijiacont='Qnet.ar' and b.bijiacont='Vdaf' and c.bijiacont='Std' and d.bijiacont='Aar'
and e.kuangming=f.kuangming
and decode(sign(f.qnet-qnet_zuigao),-1,f.qnet,0,qnet_zuigao,1,qnet_zuigao)>a.value_s and decode(sign(f.qnet-qnet_zuigao),-1,f.qnet,0,qnet_zuigao,1,qnet_zuigao)<=a.value_x and f.Vdaf>b.value_s and f.Vdaf<=b.value_x
and f.stad>c.value_s and f.stad<=c.value_x and f.aar>d.value_s and f.aar<=d.value_x
and e.kuangming='0107'
and to_char(f.fahuor,'MM/YY')='06/01' WITH READ ONLY ) bb
where aa.fahuor=bb.fahuor and aa.chepihao=bb.chepihao ;