Contents
SET SERVEROUTPUT ON
DECLARE
emp_rec employees%rowtype;
here number:=0;
CURSOR emp_cur IS
SELECT *
FROM Employees;
-- WHERE salary > 10;
BEGIN
OPEN emp_cur;
LOOP
FETCH emp_cur INTO emp_rec;
EXIT WHEN emp_cur%NOTFOUND;
select count(*) into here
from job_history where employee_id=emp_rec.employee_id ;
dbms_output.put_line (emp_rec.first_name || ' ' || emp_rec.last_name||here);
END LOOP;
CLOSE emp_cur;
END;
kodi: 197 emri: Kevin mbiemri: Feeney
gap :197->199 gap=1
kodi: 199 emri: Douglas mbiemri: Grant
kodi: 200 emri: Jennifer mbiemri: Whalen
kodi: 201 emri: Michael mbiemri: Hartstein
set serveroutput on;
Declare
cursor e_c is select employee_id,first_name,last_name
from employees order by employee_id ;
kodi NUMBER;
k1 number;
k2 number;
step number;
gaps number:=0;
emri varchar2(50);
mbiemri varchar2(50);
begin
OPEN e_c;
FETCH e_c into KODI,EMRI,mbiemri;
k1:=kodi;
k2:=kodi;
while e_c%FOUND LOOP
dbms_output.put_line('kodi: '||kodi||' emri: '||emri||' mbiemri: '||mbiemri);
step:=k2-k1-1;
if(step>0) then
dbms_output.put_line('gap :'||k1||'->'||k2||' gap='||step);
end if;
gaps:=gaps+step;
close e_c;
dbms_output.put_line('gaps: '||gaps);
end;