Select Query in Select List

[silasmw]

SELECT department_name, CURSOR(SELECT salary, commission_pct
FROM employees e
WHERE e.department_id = d.department_id)
FROM departments d;

when executed this return an error

ORA-00932: Inconsistent Datatypes,

Cursor is used in declaration section of pl/sql blocks!

Rewrite this query with a normal join:

SELECT d.department_name, e.salary, e.commission_pct
FROM employees e, departments d
WHERE e.department_id = d.department_id;