一个视图的问题.

[wavestudio]

同一个视图定义语句，在oracle816下面顺利编译通过，在oracle805下面报错，错误为缺少表达式，请高手帮我看看。
select a.borrowno,a.name,b.deptname from LIUJING.DABORROWCARD a, LIUJING.vsdept b
where a.dept=b.deptcode and a.borrowno in
(select borrowno from liujing.DAARCHIVESUSE
where borrowdt+(select abilityvalue from liujing.daBorrowAbility where batype=1)<sysdate)

[armu80830]

borrowdt+(select abilityvalue from liujing.daBorrowAbility where batype=1)<sysdate
这段估计在oracle805下通过不了

[beckhambobo]

可这样是否行？
select a.borrowno,a.name,b.deptname from LIUJING.DABORROWCARD a, LIUJING.vsdept b
where a.dept=b.deptcode and a.borrowno in
(select borrowno from liujing.DAARCHIVESUSE
where (select DAARCHIVESUSE.borrowdt+abilityvalue from liujing.daBorrowAbility where batype=1)<sysdate)

[beckhambobo]

可这样是否行？
select a.borrowno,a.name,b.deptname from LIUJING.DABORROWCARD a, LIUJING.vsdept b
where a.dept=b.deptcode and a.borrowno in
(select borrowno from liujing.DAARCHIVESUSE
where (select DAARCHIVESUSE.borrowdt+abilityvalue from liujing.daBorrowAbility where batype=1)<sysdate)

[klbt]

学习。