Select Query in Select List

[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?

[pando]

because you have more than one column, if that column was using a defined type it probably works

[jmodic]

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;