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

what is the difference between data migration and production migration.

2397

How do I know if oracle is installed on windows?

984

List out the difference between commit, rollback, and savepoint?

1094

Explain the use of record length option in exp command.

1117

When do I need to use a semicolon vs a slash in oracle sql?

1141

What is java oracle used for?

1075

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

1116

How do I escape a reserved word in oracle?

1255

What is the usage of control file in oracle?

1141

What is logical backup in oracle?

1082

How many types of table in Oracle?

1172

What are the types of trigger in oracle?

1028

How to pass parameters to procedures in oracle?

1082

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2367

How to call a stored function in oracle?

1064