Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- CURSOR c1 IS SELECT
- e.ID_OSRODEK,
- o.NAZWA_O,
- TO_NUMBER(TO_CHAR(e.DATA_EGZ, 'yyyy')) AS ROK,
- TO_NUMBER(TO_CHAR(e.DATA_EGZ, 'MM')) AS MIESIAC,
- COUNT(e.NR_EGZ) AS LICZBA
- FROM EGZAMINY e
- JOIN OSRODKI O ON e.ID_OSRODEK = O.ID_OSRODEK
- GROUP BY e.ID_OSRODEK, o.NAZWA_O, TO_NUMBER(TO_CHAR(e.DATA_EGZ, 'yyyy')),
- TO_NUMBER(TO_CHAR(e.DATA_EGZ, 'MM'));
- BEGIN
- FOR data IN c1 LOOP
- INSERT INTO TLMOSRODKI (ROK, MIESIAC, ID_OSRODEK, NAZWA_O, LICZBA) VALUES
- (data.ROK, data.MIESIAC, data.ID_OSRODEK, data.NAZWA_O, data.LICZBA);
- END LOOP;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement