From oracle-l-bounce@freelists.org Thu Jul 15 09:28:25 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6FESAE09061 for ; Thu, 15 Jul 2004 09:28:20 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6FERx609009 for ; Thu, 15 Jul 2004 09:28:10 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4079E72C19A; Thu, 15 Jul 2004 09:08:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06850-77; Thu, 15 Jul 2004 09:08:08 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5690472C124; Thu, 15 Jul 2004 09:08:06 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 15 Jul 2004 09:06:41 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C1C2072C06E for ; Thu, 15 Jul 2004 09:06:40 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07884-07 for ; Thu, 15 Jul 2004 09:06:40 -0500 (EST) Received: from relay.pair.com (relay.pair.com [209.68.1.20]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 644E872C036 for ; Thu, 15 Jul 2004 09:06:40 -0500 (EST) Received: (qmail 21074 invoked from network); 15 Jul 2004 14:31:43 -0000 Received: from dynamic-173-129.oreilly.com (HELO 172.30.254.72) (209.58.173.129) by relay.pair.com with SMTP; 15 Jul 2004 14:31:43 -0000 X-pair-Authenticated: 209.197.173.129 Date: Thu, 15 Jul 2004 10:31:42 -0400 From: Jonathan Gennick X-Mailer: The Bat! (v1.62 Christmas Edition) Personal X-Priority: 3 (Normal) Message-ID: <153987283308.20040715103142@gennick.com> To: Wolfgang Breitling Subject: Re[4]: to_number question In-Reply-To: <1089900364.40f68f4c5c3ce@webmail.hosting.telus.net> References: <1089895518.40f67c5eb879e@webmail.hosting.telus.net> <70984954930.20040715095254@gennick.com> <1089900364.40f68f4c5c3ce@webmail.hosting.telus.net> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5220 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jonathan@gennick.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Thursday, July 15, 2004, 10:06:04 AM, Wolfgang Breitling (breitliw@centrexcc.com) wrote: >> 1. The subquery defines a *new* table of rows. WB> No, it does not. Ok. I've started to do a bit of digging in the 1999 ANSI SQL standard. Section 7.5 describes the FROM clause as containing a : FROM
::=
... Later, section 7.6 defines
as follows:
::=
|
can be many things, one of which is a , and a , in turn, is defined as a
. The standard does seem here, to put a subquery in the FROM clause on an equal footing with a table that you specify by name. A subquery is simply another way of specifying a table. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request@gennick.com and include the word "subscribe" in either the subject or body. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------