CREATE TABLE tb_emp AS

select empno, ename, hiredate

from emp

where 1 = 0;

DECLARE

CURSOR emp_cur IS

SELECT empno, ename, hiredate FROM emp;

TYPE nested_emp_type IS TABLE OF emp_cur%ROWTYPE;

( )

BEGIN

SELECT empno, ename, hiredate

        BULK  COLLECTINTO  emp_tab

        FROM  emp;

       FORALL i IN  1..emp_tab.COUNT

            INSERT INTO (                                                            ) ;

END;

Select e .ename from emp

E, emp m where e .mgr = m.empno

And (e.sal + nvl(e.comm, 0)) > (m.sal + nvl(m.comm, 0));

DECLARE

CURSOR cs IS select ename from emp order by sal;

i number := 1;

BEGIN

FOR erow IN cs LOOP

dbms_output.put_line(erow.ename);

i = i + 1;

EXIT WHEN i > 5;

END LOOP;