Cursor Expressions

From: Linda Turner <LindaTuner_at_hotmail.com>
Date: Sat, 13 Oct 2001 12:18:36 GMT
Message-ID: <wiWx7.9838$YC3.3534016@typhoon.southeast.rr.com>

After seeing some posts in this group, and looking at the docs (8.1.7), I am wondering how cursor expressions are used. The following, from the Oracle doc, appears to me to be very similar to a couple of nested in-line views.

What advantage do these have over in-line views?

SELECT d.deptno, CURSOR(SELECT e.empno, CURSOR(SELECT p.projnum,

                                                      p.projname
                                         FROM   projects p
                                         WHERE  p.empno = e.empno)
                        FROM TABLE(d.employees) e)

  FROM dept d
  WHERE d.dno = 605; Received on Sat Oct 13 2001 - 07:18:36 CDT