For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi all,
SELECT *
FROM dept a, emp b
WHERE a.deptno IS NOT NULL AND a.deptno = b.deptno(+)
OR (a.deptno IS NOT NULL AND a.dname NOT LIKE 'AC%');
ORA-01719: outer join operator not allowed in operand of OR or IN
Please help