How To Join Two Tables in a Single Query using Oracle?
Submitted by: AdministratorTwo tables can be joined together in a query in 4 ways in Oracle:
* Inner Join: Returns only rows from both tables that satisfy the join condition.
* Left Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the first (left) table.
* Right Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the second (right) table.
* Full Outer Join: Returns rows from both tables that satisfy the join condition, the rest of rows from the first (left) table, and the rest of rows from the second (right) table.
Submitted by: Administrator
* Inner Join: Returns only rows from both tables that satisfy the join condition.
* Left Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the first (left) table.
* Right Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the second (right) table.
* Full Outer Join: Returns rows from both tables that satisfy the join condition, the rest of rows from the first (left) table, and the rest of rows from the second (right) table.
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
| ☺ | How To Write Date and Time Interval Literals in Oracle? |
| ☺ | How To Use Values from Other Tables in UPDATE Statements using Oracle? |
| ☺ | How To Call a Stored Function in Oracle? |
| ☺ | What Happens to Indexes If You Drop a Table? |
| ☺ | What Is the Relation of a User Account and a Schema? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Forms Reports Interview Questions. |
