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

What are the various constraints used in oracle?

1026

What are the parameters that we can pass through a stored procedure?

1048

How do we get field details of a table?

970

How to store pictures on to the database?

954

State the difference between a primary key and foreign key?

921

How do I find my oracle client driver version?

1020

What are the benefits of ordbms?

1071

How to manage transaction isolation level?

983

List out the types of joins.

1137

Explain the importance of .pll extension in oracle?

988

How to connect ms access to oracle servers?

981

What is snapshot is too old? Give and example for better understand.

1591

Difference between inner join vs where ?

1012

What is an oracle cursor variable?

1047

What are the common oracle dba tasks?

1124