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 is a sub query? Describe its types?

1071

How does Oracle guarantee data integrity of data changes?

2456

What is meant by raw datatype?

1117

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2203

How to delete a user account in oracle?

1021

What are the differences between primary key and unique key?

1058

Can we commit inside a function in oracle?

1012

What are operators in oracle?

1101

Give the advantages and disadvantages of clusters.

1096

Why do we need integrity constraints in a database?

1076

What is a subquery?

1191

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2145

How to check the server version in oracle?

1140

What is the difference between hot backup and cold backup in oracle?

1076

IS it possible to built the oracle database without setting the kernal parameters?

2393