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 set operators?

1059

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1080

What is the use of file param in imp command?

1146

What is difference between sid and service name in oracle?

941

Difference between cartesian join and cross join?

1006

What is difference between cartesian join and cross join?

1068

What are oracle functions?

1006

List the types of joins used in writing subqueries?

980

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2030

What are the database administrators utilities available?

1006

What is the scope of a local variable?

1042

How many types of tables supported by oracle?

1054

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1902

How can I combine multiple rows into a comma-delimited list in oracle?

1038

Can a parameter be passed to a cursor?

1099