inner Join used for Display All Match Data From two or multible table.

What different of iner joint & outer joint with example

Question Posted / rizwan khan

Answer Posted / rizwan khan

inner Join used for Display All Match Data From two or
multible table.

Outer Join :- Display All unmached data.

Is This Answer Correct ?

4 Yes

8 No

Please Help Members By Posting Answers For Below Questions

How to loop through a cursor variable?

1087

How to load excel data sheet to oracle database

1025

What are nested tables?

1176

How many types of segments in Oracle?

1070

What are the limitations oracle database 10g xe?

1046

Can the query output be sorted by multiple columns in oracle?

992

List out the components of logical database structure of oracle database.

1039

How to see the table columns used in an index?

1024

How to get the Installed Oracle Version Information ?

1125

How oracle handles dead locks?

1066

How to call a stored function with parameters?

1047

What is a static data dictionary in oracle?

1113

What is the use of file param in imp command?

1165

What is a data dictionary and how can it be created?

1151

What are advantages of dateset in datastage?

2263