The Database Knowledgebase on the Web

KNOWLEDGEBASE:

SQL

Oracle

MySQL

Postgres 

General topics 

Glossary 

Glossary

Select a letter to browse the glossary. You may also enter a search phrase in the Google search box below to search the entire site.

0 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


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.

Contact: Lewis Cunningham
lewisc@databasewisdom.com

About us

Contact us

Support us

Authors, Share Your Book with Millions of Readers

Search Database Wisdom