When the data required by the user is in more than one table, then Join comes into the picture. Oracle Join is used to combine the rows from more than one tables. Join also retrieves data from multiple tables and creates a new table.

BY Best Interview Question ON 19 Feb 2019