Well, the last example was from 8.1.6. This one is from 9.2.0.1. How does that work now?

oracle9@matjac:{116} sqlplus scott/tiger

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Aug 8 14:04:49 2002

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production


USER NAME SYSDATE
------------------------------ --------- -----------
SCOTT MIGRA40 08-AUG-2002

SQL> select dname, (select empno, mgr from emp) from dept;
select dname, (select empno, mgr from emp) from dept
*
ERROR at line 1:
ORA-00913: too many values