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 suggestions do you have to reduce the network traffic?

899

various types of hints and their usage

2623

What happens if the imported table already exists?

970

Can we write insert statement in function in oracle?

1025

How to estimate disk space needed for an export job?

989

Explain about the analyze command in oracle?

995

How to connect the oracle server as sysdba?

1008

Is primary key indexed by default in oracle?

928

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2573

Explain the features of oracle?

988

How to calculate date and time differences in oracle?

990

What are transaction isolation levels supported by oracle?

993

What is a database table in oracle?

950

When do you get a .pll extension in oracle? Explain its importance

984

What is the data pump export utility?

1020