Difference between inline view and WITH clause?
There are some important differences between  inline views (derived tables) and WITH clause(CTE) in Oracle.  Some of them are quite universal, i.e. are applicable to other RDBMS. 


WITH can be used to build recursive subqueries, inline view -not (as far as I know the same is for all RDBMS that support CTE) 
Subquery in WITH clause is more likely be physically executed first ; in many cases, choosing between WITH and inline view makes optimizer to choose different execution plans (I guess it's vendor specific, maybe even version specific ). 
Subquery in WITH can be materialized as a temporary table ( I'm not aware if any other vendor but Oracle supports this feature).
Subquery in WITH can be referenced multiple times , in other subqueries, and in the main query (true for most RDBMS).