Santosh

• Apr 16th, 2006

 

If we write a query in the from clause then this is called inline view or online query.

Guest

• Jun 28th, 2006

 

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.

select
   fs.tablespace_name                          "Tablespace",
   (df.totalspace - fs.freespace)              "Used MB",
   fs.freespace                                "Free MB",
   df.totalspace                               "Total MB",
   round(100 * (fs.freespace / df.totalspace)) "Pct. Free"
from
   (select
      tablespace_name,
      round(sum(bytes) / 1048576) TotalSpace
   from
      dba_data_files
   group by
      tablespace_name
   ) df,
   (select
      tablespace_name,
      round(sum(bytes) / 1048576) FreeSpace
   from
      dba_free_space
   group by
      tablespace_name
   ) fs
where
   df.tablespace_name = fs.tablespace_name;

Anonymous

• Nov 5th, 2006

 

You can find a related discussion at http://forums.oracle.com/forums/thread.jspa?messageID=1473644

Anonymous

• Nov 5th, 2006

 

Actually, the optimizer will execute an inline view exactly the same way it would execute an ordinary view. There is a related thread at Oracle Forums.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

 

when a query is given inplace of tablename in from cluse .  The query becomes a inline view.

g_sidhu

 Profile 

• Feb 6th, 2008

 

An inline view is created by placing a subquery in the FROM clause and giving that subquery an alias. The subquery defines a data source that can be referenced in the main query.