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 drop an index?

1015

What happens to the current transaction if the session is killed?

1038

Why packages are used in oracle?

1118

Describe an oracle table?

1099

List out the types of joins.

1240

What is oracle database 10g express edition?

1172

Explain self joins in oracle?

1063

What is a table in oracle?

1024

Is there a combination of "like" and "in" in sql?

1116

How to load data through external tables?

1190

Can we create database in oracle using command line ?

1134

What is data type in oracle?

1185

How to define an external table with a text file?

1127

State any two functions of oracle?

1099

What is the difference between alert log file and tarce file ?

2232