Snippet Name: WITH Clause: Double 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: Single alias
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: February 26th, 2009
|
|