Re: Can FROM be followed by a SELECT statement instead a table name?

From: steph <stephan0h_at_yahoo.de>
Date: Thu, 16 Apr 2009 04:54:14 -0700 (PDT)
Message-ID: <4be88a15-af45-4ced-a6f5-5add3897a37d_at_z9g2000yqi.googlegroups.com>

On 16 Apr., 13:52, Phper <hi.steven..._at_gmail.com> wrote:
> Can FROM be followed by a SELECT statement instead a table name?

yes:

select a from (select 1 a from dual); Received on Thu Apr 16 2009 - 06:54:14 CDT

This message: [ Message body ]
Next message: steph: "Re: Can I use a stored procedure to return a table?"
Previous message: Phper: "Can FROM be followed by a SELECT statement instead a table name?"
In reply to: Phper: "Can FROM be followed by a SELECT statement instead a table name?"
Next in thread: Mladen Gogala: "Re: Can FROM be followed by a SELECT statement instead a table name?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message