Question: what is the difference between inline view and subquery?
Answer: Sub query in oracle:- In oracle, we can define query in WHERE clause of the select statement. It is called sub query because it is a query in another query. The difference between inline view and sub query is, inline view is used in FROM clause and sub query is used in WHERE clause.