Re: Cursors with multiple selects

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 9 Oct 2001 06:16:53 -0700
Message-ID: <9putc507bg@drn.newsguy.com>

In article <3bc2afc3$0$3643$626a54ce_at_news.free.fr>, "Vigi98" says...
>
>Hi all,
>
>I'm wondering if it is possible to fill in a cursor in another way that
>"OPEN CURSOR FOR SELECT...".
>
>Eg, is it possible to fiil in it with several select ?
>
>--
>
>====================================================
>Anselme HUBER CAP GEMINI Telecom
>Phone : +33 (0)4 76 52 63 09 GSM : +33 (0)6 83 87 39
>07
>FAX : +33 (0)4 76 52 62 01 Mailto:
>anselme.huber_at_cgey.com
>
>
>

sigh, never a version, never ever a version......

sure, assuming you have the correct version:

scott_at_ORA817DEV.US.ORACLE.COM> select cursor( select ename from emp ), cursor( select dname from dept ) from dual;

CURSOR(SELECTENAMEFR CURSOR(SELECTDNAMEFR

-------------------- --------------------

CURSOR STATEMENT : 1 CURSOR STATEMENT : 2 CURSOR STATEMENT : 1 ENAME

---

A
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
SCOTT
KING
TURNER
ADAMS
JAMES
FORD
MILLER 14 rows selected.

CURSOR STATEMENT : 2 DNAME

---

ACCOUNTING
RESEARCH
SALES
OPERATIONS

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 

Received on Tue Oct 09 2001 - 08:16:53 CDT