User Tools

Site Tools


kurs:cursor
PROCEDURE PC_CURSOR
   IS
    cursor c_max_salary is
        SELECT employees.first_name, employees.last_name, jobs.job_id, jobs.job_title,
            jobs.min_salary, jobs.max_salary
        FROM jobs, employees
        WHERE ((jobs.job_id = employees.job_id));

    type job_emp is record (
        first_name varchar2(20),
        last_name varchar2(20),
        job_id varchar2(10),
        job_title varchar2(35),
        min_salary number(6),
        max_salary number(6));

    jobs_record job_emp;
    
BEGIN
    open c_max_salary;
    
    for iInd in 1..9 loop
        fetch c_max_salary into jobs_record;
        dbms_output.put_line(jobs_record.last_name||' '||jobs_record.job_id||' '||jobs_record.job_title||' '||jobs_record.max_salary);
    end loop;
    
    close c_max_salary;
    
END; -- Procedure
kurs/cursor.txt · Last modified: 2014/09/10 21:22 (external edit)