Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SERVEROUTPUT ON
- CREATE OR REPLACE PROCEDURE zad_2e (rok NUMBER) IS
- CURSOR kursor_1 IS SELECT osoby.id_os, osoby.imie, osoby.nazwisko, stanowiska.nazwa_st, etaty.data_zat, etaty.data_zw FROM ETATY,OSOBY,STANOWISKA
- WHERE etaty.id_os = osoby.id_os AND stanowiska.id_st = etaty.id_st;
- BEGIN
- FOR i IN kursor_1
- LOOP
- IF i.data_zw IS NOT NULL THEN
- IF EXTRACT(YEAR FROM i.data_zw)>=EXTRACT(YEAR FROM TO_DATE(rok,'YYYY')) AND EXTRACT(YEAR FROM i.data_zat)<=EXTRACT(YEAR FROM TO_DATE(rok,'YYYY')) THEN
- DBMS_OUTPUT.put_line(i.imie || ' ' || i.nazwisko || ' ' || i.nazwa_st);
- END IF;
- ELSIF EXTRACT(YEAR FROM i.data_zat)<=EXTRACT(YEAR FROM TO_DATE(rok,'YYYY')) THEN DBMS_OUTPUT.put_line(i.imie || ' ' || i.nazwisko || ' ' || i.nazwa_st);
- END IF;
- END LOOP;
- END;
- /
- CALL zad_2e(2006);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement