Oracle PL/SQL: WITH Clause: Single alias - The WITH query name clause provides a way assign a name to a subquery block. The subquery block can

Quick Search:

Oracle PL/SQL: WITH Clause: Single alias

Jump to:

Category: >> Oracle PL/SQL >> WITH Clause: Single alias

<< last

next >>

Snippet Name: WITH Clause: Single alias

Description: The WITH query_name clause provides a way assign a name to a subquery block. The subquery block can then be referenced in multiple places in the query by specifying the query name. The query is optimized by treating it as either an inline view or as a temporary table.

Also see:
» AND Condition
» Distinct
» Having Clause
» EXISTS 2
» EXISTS
» WITH with CONNECT BY
» WITH Clause: Double alias

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: February 26th, 2009

WITH <alias_name> AS (subquery_sql_statement)
     SELECT <column_name_list> FROM <alias>;
     WITH xyz AS (SELECT dummy FROM dual)
SELECT dummy FROM xyz;