Originally posted by stecal So why didn't the example I posted originally, and the one for 9i, not work? Too many columns in the second select statement? Why does that work in your examples and not mine?
I have told you allready - because your syntax is wrong! With correct syntax it works both in 8.1.7 and in 9i.
Your (wrong) syntax:
SQL> select dname, (select empno, mgr from emp) from dept;
The correct syntax for such example - you must use CURSOR expression:
SQL> select dname, CURSOR(select empno, mgr from emp) from dept;
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?