SQL1:SELECT * FROM dwb_dbillinfo_arch dbi
WHERE EXISTS (SELECT 1 FROM (
SELECT DISTINCT vb.ID,vb.unittype FROM vtru_bureau vb CONNECT BY PRIOR vb.ID=vb.parentid
START WITH instrb(';'||120001060||';' , ';'||vb.ID||';')>0 ) t
WHERE t.unittype='B' AND t.ID=dbi.bureauid)SQL2:SELECT * FROM dwb_dbillinfo_arch dbi
WHERE ('120001060' IS NULL OR dbi.bureauid IN (SELECT ID FROM (
SELECT DISTINCT vb.ID,vb.unittype FROM vtru_bureau vb CONNECT BY PRIOR vb.ID=vb.parentid
START WITH instrb(';'||120001060||';' , ';'||vb.ID||';')>0 ) t
WHERE t.unittype='B'))SQL3:SELECT * FROM dwb_dbillinfo_arch dbi
WHERE dbi.bureauid IN (SELECT ID FROM (
SELECT DISTINCT vb.ID,vb.unittype FROM vtru_bureau vb CONNECT BY PRIOR vb.ID=vb.parentid
START WITH instrb(';'||120001060||';' , ';'||vb.ID||';')>0 ) t
WHERE t.unittype='B')上面的SQL1和SQL2执行时报如标题据说的错误,SQL3执行却没问题。
各位大侠,帮忙看看。
WHERE EXISTS (SELECT 1 FROM (
SELECT DISTINCT vb.ID,vb.unittype FROM vtru_bureau vb CONNECT BY PRIOR vb.ID=vb.parentid
START WITH instrb(';'||120001060||';' , ';'||vb.ID||';')>0 ) t
WHERE t.unittype='B' AND t.ID=dbi.bureauid)SQL2:SELECT * FROM dwb_dbillinfo_arch dbi
WHERE ('120001060' IS NULL OR dbi.bureauid IN (SELECT ID FROM (
SELECT DISTINCT vb.ID,vb.unittype FROM vtru_bureau vb CONNECT BY PRIOR vb.ID=vb.parentid
START WITH instrb(';'||120001060||';' , ';'||vb.ID||';')>0 ) t
WHERE t.unittype='B'))SQL3:SELECT * FROM dwb_dbillinfo_arch dbi
WHERE dbi.bureauid IN (SELECT ID FROM (
SELECT DISTINCT vb.ID,vb.unittype FROM vtru_bureau vb CONNECT BY PRIOR vb.ID=vb.parentid
START WITH instrb(';'||120001060||';' , ';'||vb.ID||';')>0 ) t
WHERE t.unittype='B')上面的SQL1和SQL2执行时报如标题据说的错误,SQL3执行却没问题。
各位大侠,帮忙看看。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货