Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Cursor Expressions
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
![]() |
![]() |