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

Home -> Community -> Usenet -> c.d.o.misc -> Re: What ver supports "virtual" tables in FROM clause?

Re: What ver supports "virtual" tables in FROM clause?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 21 Sep 1999 14:16:17 +0100
Message-ID: <937920201.5587.3.nnrp-12.9e984b29@news.demon.co.uk>

Your version of Oracle supports this feature, but I think the problem is the 'AS' keyword appearing before the view aliases. This is an optional extra when creating column
aliases, but an error when creating table aliases.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Phil R Lawrence wrote in message <7s7v6n$1gh0_at_fidoii.cc.Lehigh.EDU>...
>Hi,
>
>Mr. Kats gave me a great solution to a problem involving "virtual" tables
in
>the FROM clause. (See his message below) However, my SQLPlus is
>complaining "ORA-00933: SQL command not properly ended" when it reaches the
>"as B,".
>
>What version of Oracle began support for this sort of querying? I have
>version 7.3.4.
Received on Tue Sep 21 1999 - 08:16:17 CDT

Original text of this message

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