Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- id_temp number(6);
- imie_temp varchar(20);
- nazwisko_temp varchar(25);
- wynik NUMBER;
- BEGIN
- select
- employees.employee_ID,
- employees.first_name,
- employees.last_name,
- employees.salary
- into
- id_temp,
- imie_temp,
- nazwisko_temp,
- wynik
- from
- employees
- where
- salary in
- (select max(salary) from employees);
- dbms_output.put_line(id_temp);
- dbms_output.put_line(imie_temp);
- dbms_output.put_line(nazwisko_temp);
- dbms_output.put_line(wynik);
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement