-
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?
-
because you have more than one column, if that column was using a defined type it probably works
-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|