Explain self joins in oracle?
A self join means in a table each row is joined to other rows in the table and also to itself
Here, the standard JOIN command is used in which both the tables in the join are the same tables.
BY Best Interview Question ON 19 Feb 2019
Example
SELECT T2.name
FROM category T1
JOIN category T2
ON T2.parent = T1.id
WHERE T1.name = 'Best interview questions.'