the difference between A.x=B.x(+) is a outer join and A.x=B.x is a inner j

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

Answer Posted / guest

the difference between A.x=B.x(+) is a outer join and
A.x=B.x is a inner join.

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain about your project and its relation to the current job position you are applying to?

988

What is set operator oracle?

954

What is sharded cluster?

990

How do I find the database name in oracle?

1015

What is using clause and give example?

1014

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2040

How to define a data field as not null?

1091

Explain oracle data types with examples?

1004

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2806

What is snapshot is too old? Give and example for better understand.

1587

Difference between pre-select and pre-query

1080

Can we store pictures in the database and if so, how it can be done?

1012

Use of an integrity constraint is better to validate data. Explain

1019

How to retrieve data from an explicit cursor?

1037

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2115