What is an Inline view?

Inline view is a sub query with an alias that you can use like a view inside a SQL statement. It’s not a schema object like normal view. i.e.

select e.deptno, v.dname , sum(e,sal)

from emp e,

(select distinct d.dname, d.deptno from dept d) v

Where e.deptno = v.deptno

Group by e.deptno, v.dname;