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