what is (+) syntax in SQL query

Question

I want to know what the (+) in the below query signify,

select ..
from ..., Fat fat
where prop = fat.prop (+)

Thanks

What did you research? (Google/Bing/MySql Book) – Elias Oct 15 '13 at 18:50 — Elias, Oct 15 '13 at 18:50

Rahul Tripathi · Accepted Answer · 2013-10-15T18:39:13.870

1

It is the obsolete outer join symbol.

In Oracle, (+) denotes the "optional" table in the JOIN.

You may check out this for Left and Right Outer Joins.

On a side note:-(Although its obsolete)

The placement of the (+) determines RIGHT or LEFT. If the (+) is on the right, it's a LEFT JOIN and if (+) is on the left, it's a RIGHT JOIN.

edited Oct 15 '13 at 18:39

answered Oct 15 '13 at 18:33

Rahul Tripathi

161,154
30
262
319

1

thanks for the answer. – user2883743 Oct 15 '13 at 18:53
@user2883743:- You are welcome! – Rahul Tripathi Oct 15 '13 at 18:53

score 0 · Answer 2 · answered Oct 15 '13 at 18:33

0

For Oracle specifically, indicates a Left Outer Join. Older notation.

answered Oct 15 '13 at 18:33

asantaballa

3,768
1
19
20

score 0 · Answer 3 · answered Oct 15 '13 at 18:35

0

Out of date format of outer join. Means only matching rows on the (+) sign side and all rows on the other side. You should use the LEFT/RIGHT OUTER JOIN notation instead.

answered Oct 15 '13 at 18:35

amphibient

27,548
48
136
231

what is (+) syntax in SQL query

3 Answers3