Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SERVEROUTPUT ON;
- DECLARE
- TYPE emp_table_type IS TABLE OF emp%ROWTYPE
- INDEX BY BINARY_INTEGER;
- emp_record emp%ROWTYPE;
- emp_table emp_table_type;
- hire_date_n emp.hiredate%TYPE;
- text_modificat VARCHAR2(16);
- BEGIN
- SELECT *
- INTO emp_table(1)
- FROM emp
- WHERE ename = 'BLAKE';
- SELECT *
- INTO emp_table(2)
- FROM emp
- WHERE ename = 'SCOTT';
- SELECT *
- INTO emp_table(3)
- FROM emp
- WHERE ename = 'KING';
- SELECT *
- INTO emp_table(4)
- FROM emp
- WHERE ename = 'FORD';
- FOR index_angajat IN 1..emp_table.COUNT LOOP
- hire_date_n := TRUNC(emp_table(index_angajat).hiredate, 'MONTH');
- IF EXTRACT(DAY FROM emp_table(index_angajat).hiredate) <> '1' THEN
- emp_table(index_angajat).hiredate := hire_date_n;
- text_modificat := 'MODIFICAT';
- ELSE
- text_modificat := 'NEMODIFICAT';
- END IF;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement