One possibility would be:

SELECT ename,
cursor (select language from lang l where l.empno = e.empno),
cursor (select school from cert c where c.empno = e.empno)
FROM emp e
/

SY.

I do not have much SYBASE, maybe someone else could answer that part of your question. Cusror expressions are supported in SQL*Plus, however output looks ugly (as an example I will use scott/tiger emp and dept tables):

SQL> select dname,cursor (select ename from emp e where e.deptno = d.deptno) as elist from dept d;

DNAME ELIST
-------------- --------------------
ACCOUNTING CURSOR STATEMENT : 2

CURSOR STATEMENT : 2

ENAME
----------
CLARK
KING
MILLER

RESEARCH CURSOR STATEMENT : 2

CURSOR STATEMENT : 2

ENAME
----------
SMITH
JONES
SCOTT
ADAMS
FORD

SALES CURSOR STATEMENT : 2

CURSOR STATEMENT : 2

ENAME
----------
ALLEN
WARD
MARTIN
BLAKE
TURNER
JAMES

6 rows selected.

OPERATIONS CURSOR STATEMENT : 2

CURSOR STATEMENT : 2

no rows selected

In PL/SQL cursor expressions are available only in 9i, and even in 9i they can not be used in FOR CURSOR loops. When fetching from such select, cursor is returned as a cursor variable (REF CURSOR):

SQL> set serveroutput on format wrapped
SQL> declare TYPE refcurtype IS REF CURSOR;
2 v_refcur refcurtype;
3 v_dname dept.dname%type;
4 v_ename emp.ename%type;
5 cursor cur
6 is
7 select dname,
8 cursor (select ename from emp e where e.deptno = d.deptno)
9 from dept d;
10 begin
11 open cur;
12 loop
13 fetch cur into v_dname,v_refcur;
14 exit when cur%notfound;
15 dbms_output.put_line(v_dname || ' department employes:');
16 loop
17 fetch v_refcur into v_ename;
18 exit when v_refcur%notfound;
19 dbms_output.put_line(' ' || v_ename);
20 end loop;
21 end loop;
22 close cur;
23 end;
24 /
ACCOUNTING department employes:
CLARK
KING
MILLER
RESEARCH department employes:
SMITH
JONES
SCOTT
ADAMS
FORD
SALES department employes:
ALLEN
WARD
MARTIN
BLAKE
TURNER
JAMES
OPERATIONS department employes:

PL/SQL procedure successfully completed.

Oracle docs do not have much info on cursor expressions, just bits here and there in SQL Reference, PL/SQL User's Guide, Performance Tuning, Application Developer's Guide).

SY.