Oracle Inline Views
Version 12.1.0.1

Basic Inline View Select
Single Table SELECT <column_name_list>
FROM (
  <SELECT_statement>);
SELECT object_type, COUNT(*)
FROM all_objects
GROUP BY object_type
;

SELECT object_type
FROM (
  SELECT object_type, COUNT(*)
  FROM all_objects
  GROUP BY object_type
);

SELECT object_type
FROM (
  SELECT object_type, COUNT(*) OTCNT
  FROM all_objects
  GROUP BY object_type)

WHERE otcnt > 100;
 
Inline View with Join
Join In-line views SELECT <column_name_list>
FROM (
  <SELECT_statement>) <alias_1>
     (
  <SELECT_statement>) <alias_2>
WHERE alias_1.condition = alias_2.condition;
conn uwclass/uwclass

SELECT table_name, num_rows
FROM user_tables
;

SELECT index_name, table_name
FROM user_indexes
;

SELECT num_rows, index_name
FROM (SELECT table_name, num_rows
      FROM user_tables) a
,
     (SELECT index_name, table_name
      FROM user_indexes
) b
WHERE a.table_name = b.table_name(+);

Related Topics
Class Setup
SELECT Statement
WHERE Clause
VIEWS

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved