Glossary

WITH - The Oracle WITH clause of the SELECT statement creates an inline temporary table for use later in a query. Unlike an inline view, the WITH clause will be instantiated once and reused through out the query. Tied with SQL Analytics, this is tremendously useful in BI and OLAP applications.