Oracle Joins

What is a JOIN? Explain types of JOIN in oracle - A join is a query that extracts data from two or more tables, views or snapshots.....
Explain various types of joins - Types of joins are: - Equijoins , Non-equijoins....
What is oracle Join? - A join is a query that combines rows of two or more tables or views.....
Guidelines for joins - Join condition should ideally be written in the FROM clause.
NON-EQUI Join, CARTESIAN Join, SELF Join, OUTER Join......