Sql query question

Question

Possible Duplicate:
Oracle "(+)" Operator

Can some one tell me what does (+) sign do in sql.. Thanks

a.sample_nbr = b.sample_nbr (+) and
a.sample_nbr = b.sub_sample_nbr (+) and

The correct answer to this question is *"They add confusion"* — ypercubeᵀᴹ, Aug 11 '11 at 18:50

score 2 · Accepted Answer · edited Jun 20 '20 at 09:12

2

outer join - wikipedia is sometimes reliable.

The (+) after b.sample_nbr makes the "b" table optional. The query returns all tables, and where there are no corresponding constraint records, Oracle supplies a null in the constraint name column.

edited Jun 20 '20 at 09:12

Community

1
1

answered Aug 11 '11 at 18:30

ring bearer

19,685
7
57
70

1

It can be used to specify a right outer join too. – Chandu Aug 11 '11 at 18:33
Thanks +1 -> corrected the info and added details – ring bearer Aug 11 '11 at 18:45

score 2 · Answer 2 · answered Aug 11 '11 at 18:31

2

The plus sign in Oracle specifies an outer join.

answered Aug 11 '11 at 18:31

Christopher Armstrong

7,747
2
25
28

Sql query question

2 Answers2