SQL> declare
  2    cursor cur_e is                               --> this is a cursor declaration
  3      select e.ename, e.job, d.dname, e.sal, b.comm
  4      from emp e, dept d, bonus b     
  5      where e.deptno = d.deptno
  6        and b.ename (+) = e.ename
  7      order by d.dname, e.ename, b.comm;          --> this is the ORDER BY clause
  8    cur_r      cur_e%rowtype;
  9    l_sum_sal  number := 0;
 10  begin
 11    open cur_e;
 12    loop
 13      fetch cur_e into cur_r;
 14      exit when cur_e%notfound;
 15
 16      l_sum_sal := l_sum_sal + cur_r.sal;
 17    end loop;
 18    close cur_e;
 19    dbms_output.put_line('All of them earn ' || to_char(l_sum_sal, '$999G990D00'));
 20  end;
 21  /
All of them earn   $40,225.00

PL/SQL procedure successfully completed.

SQL>