0 votes
in Oracle by
Q.What is meant by Joins in Oracle? List the types of Joins of Oracle?

1 Answer

0 votes
by

Joins are used to extract data from multiple tables using some common columns or conditions.

There are various types of Joins as listed below:

  • INNER JOIN
  • OUTER JOIN
  • CROSS JOINS or CARTESIAN PRODUCT
  • EQUI JOIN
  • ANTI JOIN
  • SEMI JOIN

Related questions

+1 vote
asked Jul 29, 2020 in Oracle by Hodge
0 votes
0 votes
asked May 11, 2020 in Oracle by JackTerrance
...