Re: PL/SQL complex selects

From: David Schweisguth <davids_at_tracy.pangeasystems.com>
Date: 7 Oct 1998 15:18:58 GMT
Message-ID: <6vg0p2$oee$1@pornstorm.geo.net>

Sergei Kuchin (skuchin_at_sprynet.com) wrote:
: > Gocha Mchedlishvili wrote:
: > > DECLARE
: > > CURSOR MyCursor IS
: > > SELECT * FROM ( SELECT * FROM MyTable)
: > >
: > > But I'm getting an error [...]
: > >
: Very simple. In Oracle 7.x, PL/SQL DOES NOT support inline views but it
: works in Oracle 8.

Inline views are supported in Oracle 7.3's PL/SQL. They aren't supported in 7.3's Pro*C (or at least aren't fully supported), but you can hide them in stored procedures.

Dave Schweisguth                              Work: davids_at_pangeasystems.com
Pangea Systems                                Home: dschweisguth_at_earthlink.net

Received on Wed Oct 07 1998 - 10:18:58 CDT