Advertisement
Guest User

Untitled

a guest
Dec 10th, 2019
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. DECLARE
  2. id_temp number(6);
  3. imie_temp varchar(20);
  4. nazwisko_temp varchar(25);
  5. wynik NUMBER;
  6. BEGIN
  7. select
  8. employees.employee_ID,
  9. employees.first_name,
  10. employees.last_name,
  11. employees.salary
  12. into
  13. id_temp,
  14. imie_temp,
  15. nazwisko_temp,
  16. wynik
  17. from
  18. employees
  19. where
  20. salary in
  21. (select max(salary) from employees);
  22. dbms_output.put_line(id_temp);
  23. dbms_output.put_line(imie_temp);
  24. dbms_output.put_line(nazwisko_temp);
  25. dbms_output.put_line(wynik);
  26. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement