Inline view
From Oracle FAQ
An inline view is a SELECT statement in the FROM-clause of another SELECT statement. In-line views are commonly used simplify complex queries by removing join operations and condensing several separate queries into a single query. This feature was introduced in Oracle 7.
[edit]
Examples
Example inline view:
SELECT *
FROM (select deptno, count(*) emp_count
from emp
group by deptno) emp,
dept
WHERE dept.deptno = emp.depto;
[edit]
Also see
- Subquery - don't confuse inline views with subqueries!
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
