A.x = B.x(+) is outer join. A.x = B.x is inner join of two tables

A and B are tables. x is a column. Then What is difference
between A.x = B.x(+) and A.x = B.x ?

Question Posted / surya

Answer Posted / surya

A.x = B.x(+) is outer join.
A.x = B.x is inner join of two tables

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to delete a column in an existing table?

1081

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122

What is Java Pool in Oracle?

1179

Why do we need oracle client?

964

What are the limitations oracle database 10g xe?

1052

Explain the different normalization forms?

1112

How many types of synonyms in Oracle?

1133

How to get maxsal , minsal, ename department wise in single query

1555

How to insert a new row into a table in oracle?

1168

What is tns entry?

1164

What are the different types of synonyms?

1143

How to do a full database export?

1117

What happens in oracle commit?

1033

What are the various constraints used in oracle?

1052

What is the use of file param in imp command?

1167