what is inline view with example and it's uses

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

what is inline view with example and it's uses

Postby saravana572 » Tue Nov 20, 2012 2:42 am

can any one attach pdf materail for views plz
saravana572
Member
 
Posts: 2
Joined: Fri Nov 09, 2012 3:32 am

Re: what is inline view with example and it's uses

Postby Tim... » Tue Nov 20, 2012 9:20 am

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle SQL and PL/SQL Development

Who is online

Users browsing this forum: No registered users and 0 guests