what is inline view with example and it's uses

[saravana572]

can any one attach pdf materail for views plz

[Tim...]

Hi.

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.php
http://www.oracle-base.com/articles/mis ... clause.php

Cheers

Tim...