Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE PROCEDURE powyzej(liczba NUMBER)
- AS
- chuj produkty%ROWTYPE;
- BEGIN
- FOR produkty IN (SELECT COUNT(*), produkty.cena FROM produkty
- WHERE produkty.cena > liczba
- GROUP BY produkty.cena)
- LOOP
- DBMS_OUTPUT.put_line(chuj.nazwa);
- END LOOP;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement