code_junkie

Meaning of (+) in SQL queries

Nov 14th, 2011
251
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. SELECT *
  2. FROM a, b
  3. WHERE b.id(+) = a.id
  4.  
  5. SELECT *
  6. FROM a
  7. LEFT OUTER JOIN b
  8. ON b.id = a.id
  9.  
  10. select foo,bar
  11. from a, b
  12. where a.id = b.id+
  13.  
  14. select foo,bar
  15. from a left outer join b
  16. on a.id = b.id
Add Comment
Please, Sign In to add comment