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: 275
        
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