Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- TYPE emp_table_type IS TABLE OF
- EMPLOYEES%ROWTYPE
- INDEX BY PLS_INTEGER;
- emp_table emp_table_type;
- counter NUMBER(6) := 100;
- BEGIN
- FOR i IN
- 1..4
- LOOP
- SELECT *
- INTO emp_table(i)
- FROM EMPLOYEES
- WHERE EMPLOYEE_ID = counter;
- counter := counter + 10;
- DBMS_OUTPUT.PUT_LINE(emp_table(i).LAST_NAME);
- END LOOP;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement