A.x = B.x(+) is a left outer join and it will return all the values

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 / pradeep

Answer Posted / pradeep

A.x = B.x(+) is a left outer join and it will return
all the values of x from A table.
A.x = B.x is a inner join.

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to set a transaction to be read only in oracle?

1033

How to use fetch statement in a loop?

973

How view is different from a table?

968

Why do you create or replace procedures rather that drop and recreate.

947

Is oracle a language?

900

What is a cursor and what are the steps need to be taken?

1118

Is rowid unique in oracle?

939

How to connect asp pages to oracle servers?

1007

Explain parameter file in oracle.

974

What do you mean by merge in oracle and how can we merge two tables?

1003

What is the recommended interval at which to run statspack snapshots, and why?

2860

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3154

How will you write a query to get a 5th rank student from a table student_report?

1814

List out the types of joins.

1083

How to load a large xml file?

1005