From: padderz <member633@dbforums.com>
Newsgroups: comp.databases.oracle
Subject: Re: any syntax similar as " with select " clause in ibm db2?
Date: Mon, 03 Mar 2003 10:05:01 +0000
Organization: dBforums
Lines: 6
Sender: padderz
Message-ID: <2596069.1046685901@dbforums.com>
References: <1673c1fd.0302281756.6c6da7e3@posting.google.com>
User-Agent: dBforums
X-Original-NNTP-Posting-Host: dbforums.com
X-Original-Trace: 3 Mar 2003 10:24:28 -0500, dbforums.com
X-Authenticated-User: paul



Agreed this is a powerful (not to mention useful) construct. The WITH
clause (a.k.a sub-query factoring) is supported in Oracle 9i.

--
Posted via http://dbforums.com