create table emp(ename char(20),empno number(10),sal number(10,3))

create table temp(my_ename char(20),my_empno number(10),my_sal number(10,3))

insert into emp values('Kiran',3214,54654.125)

insert into emp values('Rajiv',3455,7684.07)

insert into emp values('Kumar',8707,57444.00)

insert into emp values('Navya',1323,2145.10)

insert into emp values('Midhun',9025,76854.55)

select * from emp

DECLARE
    cursor c1 is select ename,empno,sal from emp order by sal desc;
    my_ename char(20);
    my_empno number(10);
    my_sal number(10,3);
BEGIN
    open c1;
    loop
        fetch c1 into my_ename,my_empno,my_sal;
        exit when(c1%rowcount >5) or (c1%notfound);
        insert into temp values(my_ename,my_empno,my_sal);
        commit;
    end loop;
    close c1;
END;

select * from emp

select * from temp