Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -KOLOKWIUM II GR II Z FB
- -
- --ZAD2
- CREATE OR REPLACE FUNCTION zad2 (IIMIE OUT MECHANICY.IMIE%TYPE, NNAZWISKO OUT MECHANICY.NAZWISKO%TYPE) RETURN NUMBER IS ILOSC NUMBER(10,2)
- BEGIN
- CURSOR CUR IS SELECT COUNT(*) cos, MECHANICY.IMIE, MECHANICY.NAZWISKO
- FROM(
- SELECT DISTINCT FROM MECHANICY
- INNER JOIN NAPRAWY USING (ID_MECH)
- WHERE MECHANICY.IMIE = IIMIE AND
- MECHANICY.NAZWISKO = NNAZWISKO
- GROUP BY MECHANICY.IMIE, MECHANICY.NAZWISKO
- ORDER BY cos DESC
- FETCH FIRST ROW ONLY;
- );
- BEGIN
- OPEN CUR;
- FETCH CUR INTO INTO ILOSC, IIMIE, NNAZWISKO;
- CLOSE CUR;
- RETURN ILOSC;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement