How to view a SQL query execution Plan in Oracle SQL*Plus

CLICK HERE

SQL> explain plan for
select d.department_name, e.first_name, e.salary, 

sum(e.salary) over (partition by e.department_id order by e.first_name) running_total

from employees e
left join departments d on e.department_id = d.department_id
order by d.department_name, e.first_name;

SQL> SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());