Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re[4]: to_number question

Re: Re[4]: to_number question

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 15 Jul 2004 08:26:36 -0700
Message-ID: <1089905196.40f6a22cd5106@webmail.hosting.telus.net>


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 <jonathan_at_gennick.com>:

> Thursday, July 15, 2004, 10:06:04 AM, Wolfgang Breitling
> (breitliw_at_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 <table reference list>:
>
> FROM <table reference list>
>
> <table reference list> ::= <table reference> ...
>
> Later, section 7.6 defines <table reference> as follows:
>
> <table reference> ::= <table primary> | <joined table>
>
> <table primary> can be many things, one of which is a
> <derived table>, and a <derived table>, in turn, is defined
> as a <table subquery>.
>
> 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_at_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
-----------------------------------------------------------------
Received on Thu Jul 15 2004 - 10:23:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US