TYPE dept_table_tab_RECORD IS RECORD (
                   DEPTNO DEPT1.deptno%TYPE,
                   DNAME  DEPT1.DNAME%TYPE,
                   LOC DEPT1.LOC%TYPE

                   );

TYPE dept_table_tab2 IS TABLE OF dept_table_tab_RECORD; -- NESTED TABLES CREATED OF A RECORD TYPE CREATED

ldata2 dept_table_tab2;
begin

SELECT   deptno,dname,loc
     BULK COLLECT INTO ldata1
     FROM   dept1;  -- ASSIGN VALUES DIRECTLY NESTED TABLES CREATED DIRECTLY AS AN EXISTING OBJECT


--I want to do something like:
insert into ldata1
select '10','Dept no 10','TX' from dual;
end;