Oracle SELF JOIN
Self Join is a specific type of Join. In Self Join, a table is joined with itself (Unary relationship). A self join simply specifies that each rows of a table is combined with itself and every other row of the table.
Oracle SELF JOIN Example
Let's take a table "customers".
Join this table using SELF JOIN as follows: