SGBD LAB 4

SET SERVEROUTPUT ON;
DECLARE
  TYPE emp_record IS RECORD(
    employee_id employees.employee_id%TYPE,
    salary employees.salary%TYPE,
    job_id employees.job_id%TYPE);
  emprec1 emp_1235%ROWTYPE;
  emprec2 emp_1235%ROWTYPE;
  angajat emp_record;
BEGIN
  SELECT * INTO emprec1
  FROM employees
  WHERE employee_id = 100;
  SELECT * INTO emprec2
  FROM employees
  WHERE employee_id = 101;
--  DELETE FROM emp_1235
--  WHERE employee_id = 100
--  RETURNING employee_id,salary,job_id into angajat;
--  DBMS_OUTPUT.PUT_LINE('Angajatul cu codul ' || angajat.employee_id || ' cu jobul ' || angajat.job_id || ' are salariul ' || angajat.salary);

  DELETE FROM emp_1235
  WHERE employee_id = 100 AND employee_id = 101;
--
--  DELETE FROM emp_1235
--  WHERE employee_id = 101;

  INSERT INTO emp_1235
  VALUES emprec1;

  INSERT INTO emp_1235
  VALUES emprec1;

END;
/
ROLLBACK;