Oracle nested selects

From: Charles Jardine (cj10_at_cam.ac.uk)
Date: 03/16/05 

Date: Wed, 16 Mar 2005 17:12:56 +0000
To:  dbi-users@perl.org

Oracle has a syntax for nested selects. E.g.

    select a, cursor(select b, ....) .....

In each row fetched from such a select, some of the column
values are themselves result sets.

DBS::Oracle version 1.16 apparently does not support such
select statements. An attempt to prepare such a statement give
the reasonable error message

> Field 2 has an Oracle type (116) which is not explicitly supported

Is anyone thinking about the implementation of the fetching of
nested result sets? If not, I might look at it myself. 

-- 
Charles Jardine - Computing Service, University of Cambridge
cj10@cam.ac.uk    Tel: +44 1223 334506, Fax: +44 1223 334679

Relevant Pages

  • Re: Performance of REGEXP_LIKE vs LIKE?
    ... There are certain situations where the syntax of REGEXP_LIKE ... is cleaner and shorter than the comparable LIKE expression. ... search of a 3 million record table, for a series of text strings. ... How about Oracle Text? ...
    (comp.databases.oracle.misc)
  • Re: Oracle input parameter of type string problem
    ... the syntax of my sproc may not be 100% correct. ... months since I have coded in Oracle and I typed the syntax from memory. ... Gregory A. Beamer ... > With the standard OleDb provider, I believe it is safe to use @Year or? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle procedure raises exception but looks to be successful from DBI
    ... is the more desirable syntax for calling oracle procedures. ... because DBI's execute method returned success even though the ... procedure raised an exception. ...
    (perl.dbi.users)
  • Re: How to decode in SQL Server 2005
    ... non-standard, non-portable features such as the join syntax, DECODE, ... NVL even though Oracle has long since supported the ... ISO standard alternatives. ... The main reason is that we use what we know best. ...
    (comp.databases.ms-sqlserver)
  • Re: Which column is taken in JOIN with multiple columns and different content ?
    ... of a more complex SQL statement. ... The syntax in Oracle would be select a.*, ... SQL> select deptno, dname, dname from dept; ...
    (comp.databases.oracle.misc)