Oracle With语句用法.docVIP

本文参考网址:HYPERLINK /reference/with.html/reference/with.html HYPERLINK /articles/misc/with-clause.php/articles/misc/with-clause.php HYPERLINK /with.html/with.html ------Understanding the WITH Claus 参考文档下载地址:HYPERLINK /fhtml/fhtml The WITH query_name clause lets you assign a name to a subquery block. You can then reference the subquery block multiple places in the query by specifying the query name. Oracle optimizes the query by treating the query name as either an inline view or as a temporary table.(WITH语句只能位于一条语句的最顶级)You can specify this clause in any top-level SE