From oracle-l-bounce@freelists.org Thu Jul 15 10:23:25 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6FFNAf23675 for ; Thu, 15 Jul 2004 10:23: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 i6FFN0623626 for ; Thu, 15 Jul 2004 10:23:10 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 86CA272C839; Thu, 15 Jul 2004 10:03:12 -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 17302-13; Thu, 15 Jul 2004 10:03:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EB2B872CC1D; Thu, 15 Jul 2004 10:03:10 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 15 Jul 2004 10:01:34 -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 8EFDC72CB32 for ; Thu, 15 Jul 2004 10:01:33 -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 16928-26 for ; Thu, 15 Jul 2004 10:01:33 -0500 (EST) Received: from priv-edtnes42.telusplanet.net (outbound05.telus.net [199.185.220.224]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 02ACA72CB7F for ; Thu, 15 Jul 2004 10:01:33 -0500 (EST) Received: from localhost ([199.185.220.240]) by priv-edtnes42.telusplanet.net (InterMail vM.6.00.05.02 201-2115-109-103-20031105) with ESMTP id <20040715152636.DWT15045.priv-edtnes42.telusplanet.net@localhost> for ; Thu, 15 Jul 2004 09:26:36 -0600 Received: from 57.80.136.6 ( [57.80.136.6]) as user centrex@hosting.telus.net@192.168.200.1 by webmail.hosting.telus.net with HTTP; Thu, 15 Jul 2004 08:26:36 -0700 Message-ID: <1089905196.40f6a22cd5106@webmail.hosting.telus.net> Date: Thu, 15 Jul 2004 08:26:36 -0700 From: Wolfgang Breitling To: oracle-l@freelists.org Subject: Re: Re[4]: to_number question References: <1089895518.40f67c5eb879e@webmail.hosting.telus.net> <70984954930.20040715095254@gennick.com> <1089900364.40f68f4c5c3ce@webmail.hosting.telus.net> <153987283308.20040715103142@gennick.com> In-Reply-To: <153987283308.20040715103142@gennick.com> MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.1-cvs X-Originating-IP: 57.80.136.6 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5236 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: breitliw@centrexcc.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org This only covers the syntax of the SQL language. I have not read the standard in detail, but I am sure that somewhere it says that it is up to the relational database engine HOW it evaluates the SQL and that it is allowed to transform the quireies. Quoting Jonathan Gennick : > Thursday, July 15, 2004, 10:06:04 AM, Wolfgang Breitling > (breitliw@centrexcc.com) wrote: > > 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. > -- Regards Wolfgang Breitling Oracle 7,8,8i,9i OCP DBA Centrex Consulting Corporation www.centrexcc.com ---------------------------------------------------------------- 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 -----------------------------------------------------------------