Почему ошибка
ORA-00936: отсутствует выражение
00936. 00000 – “missing expression”
*Cause:
*Action:
Error at Line: 4 Column: 1
select e.MANAGER_ID, e.DEPARTMENT_ID, d.DEPARTMENT_NAME, e.JOB_ID, e.FIRST_NAME, e.LAST_NAME, e.SALARY, b.SALARY/100
FROM departments d
LEFT OUTER JOIN employees (
SELECT DEPARTMENT_ID, SALARY, SALARY/100
FROM employees
ORDER BY DEPARTMENT_ID
)e
ON d.department_id = b.department_id
ORDER BY e.MANAGER_ID, e.DEPARTMENT_ID, d.DEPARTMENT_NAME, e.JOB_ID, e.FIRST_NAME, e.LAST_NAME, e.SALARY
;
