Re: SQL in Oracle Reports 2.5
From: Joe Strano <jstrano_at_dulcian.com>
Date: 1998/04/18
Message-ID: <6haimh$h8o_at_bgtnsc03.worldnet.att.net>#1/1
Date: 1998/04/18
Message-ID: <6haimh$h8o_at_bgtnsc03.worldnet.att.net>#1/1
I haven't tried this in reports. I do know that Forms 4.5 accepts this, and they both use the same version on SQL and PL/SQL. My guess is that it would work.
-- Joe Strano Dulcian, Inc. ----------------------------- Zeneca wrote:Received on Sat Apr 18 1998 - 00:00:00 CEST
> Does anyone know if it is possible to have nested sub-queries in the 'from'
> clause of a SQL query in Oracle Reports 2.5.
>
> ex.
> select a , b , c from (select a,b from (select rownum a from A where rownum
> <5) ,B) ,C
>
> This works fine in SQL+ and I beleive that it conforms to ASCII entry level
> standards