An inline view is a subquery within the FROM clause. They can allow you to do things that are not possible (or difficult) with regular joins, including ordering of data etc.
The inline view is treated the same as a real view in terms of how it is processed. You can also use subquery factoring (with clause). Check out some examples here:http://www.oracle-base.com/articles/mis ... ueries.phphttp://www.oracle-base.com/articles/mis ... clause.php