Hanu Ch Rao

• Feb 21st, 2007

 

The inline view is a construct in Oracle SQL where you can place a query in the SQL FROM, clause, just as if the query was a table name.

A common use for in-line views in Oracle SQL is to simplify complex queries by removing join operations and condensing several separate queries into a single query

vizaik

 Profile Answers by vizaik 

• Mar 24th, 2007

 

used in oracle to simplify queries

ex: select rowid from (select ename from emp group by sal) where rowid<2