Advertisement
Guest User

Untitled

a guest
Feb 5th, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.29 KB | None | 0 0
  1.  
  2. CREATE OR REPLACE PROCEDURE powyzej(liczba NUMBER)
  3. AS
  4. chuj produkty%ROWTYPE;
  5. BEGIN
  6.     FOR produkty IN (SELECT COUNT(*), produkty.cena FROM produkty
  7.     WHERE produkty.cena > liczba
  8.     GROUP BY produkty.cena)
  9.     LOOP
  10.     DBMS_OUTPUT.put_line(chuj.nazwa);
  11.     END LOOP;
  12. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement