Ćw. 6

1.

SET SERVEROUTPUT ON

DECLARE
dept_id INTEGER;
emp_id INTEGER;
emp_salary INTEGER;
BEGIN
dept_id:=50;
SELECT EMPLOYEE_ID, SALARY INTO emp_id,emp_salary FROM
(SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE DEPARTMENT_ID=dept_id ORDER BY SALARY DESC)
WHERE ROWNUM=1;
  Dbms_Output.Put_Line('EMPLOYEE ID: '||emp_id||' SALARY: ' || emp_salary);
END;
/

2.
SET SERVEROUTPUT ON
declare
  a date;
  b date;
  emp_count integer;
begin
  a := TO_DATE('&x','dd/mm/yyyy');
  b := TO_DATE('&y','dd/mm/yyyy');
   SELECT COUNT(Employee_ID) INTO emp_count FROM EMPLOYEES WHERE HIRE_DATE BETWEEN a AND b;
   SYS.DBMS_OUTPUT.PUT_LINE(emp_count);
end;
/