| 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@pdbdev
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(+); |
