while changing stored procedure i came across (+) = operator. I have read Oracle "(+)" Operator but seems like my problem is slightly different than one mentioned in that link.
So, can anyone please help me understand statement like:
select ....
from emp, dept
where emp.dept_id (+) = dept.dept_id
why would they use both + and = sign while using this condition? I would be thankful if someone will help me with example or link where i can read about such operators.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…