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

what happened to the global index when I truncate the data in one of the partition?

2009

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2111

Explain an exception?

972

What do you mean by merge in oracle and how can you merge two tables?

935

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1896

What is Data Dictionary Cache in Oracle?

1145

State some uses of redo log files?

982

Difference between open_form and call_form in oracle.

1134

What are the different types of modules in oracle forms?

989

What happens to the current transaction if a ddl statement is executed?

993

What is a partition in oracle?

1096

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2944

What is an oracle wallet?

926

What are transaction isolation levels supported by oracle?

1046

How to select some rows from a table in oracle?

1055