nested set functions

From: Roger MacNicol <roger_at_uvmark.uucp>
Date: Tue, 25 Feb 92 19:03:42 GMT
Message-ID: <1992Feb25.190342.16365_at_uvmark.uucp>


I posted this to comp.databases without getting a reply: The SQL standard says that you cannot nest set functions. Oracle does permit set functions to be nested.

  1. Does *anyone* use this feature?
  2. If so, would you mind posting some examples?
  3. Do you think Oracle has implemented this extension in an intuitive manner?
  4. Do any other databases support this extension, and if so, do they support it in the same way as Oracle?

Thanks.

-- 
 Roger MacNicol, Software Engineer
 Vmark Software, Inc., 5 Strathmore Road, Natick, MA  01760, USA
 email: uvmark%roger_at_merk.com
 Phone: (508) 655-3700, Fax: (508) 655-8395
Received on Tue Feb 25 1992 - 20:03:42 CET

Original text of this message