Oracle (Old?) Joins - A tool for conversion?
Posted
by Grasper
on Stack Overflow
See other posts from Stack Overflow
or by Grasper
Published on 2010-03-11T14:58:11Z
Indexed on
2010/03/12
21:07 UTC
Read the original article
Hit count: 225
I have been porting oracle selects, and I have been running across a lot of queries like so:
SELECT e.last_name,
d.department_name
FROM employees e,
departments d
WHERE e.department_id(+) = d.department_id;
...and:
SELECT last_name,
d.department_id
FROM employees e,
departments d
WHERE e.department_id = d.department_id(+);
Are there any guides/tutorials for converting all of the variants of the (+) syntax? What is that syntax even called (so I can scour google)?
Even better.. Is there a tool that will do this conversion for me?
When was this standard phased out? Any info is appreciated.
© Stack Overflow or respective owner