A.x=B.x(+) is not a right outer join it is left outer join

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 / ramesh

Answer Posted / ramesh

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is ADDM Advisor in Oracle?

1226

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2414

What are the arithmetic operations?

1152

Can we use bind variables in oracle stored procedure?

987

How to drop a tablespace?

1087

Explain about integrity constraint?

1180

What is the recommended interval at which to run statspack snapshots, and why?

2964

What are internal user account in oracle?

1055

What is the difference between translate and replace in oracle?

1218

What privilege is needed for a user to create tables in oracle?

993

what are bitmap indexes? How does they work?

2306

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2341

How to sort output in descending order in oracle?

1104

How oracle handles dead locks?

1131

How to connect to the server with user account: sys?

1063