PLSQL_Table_Type2.htm
PL/SQL offers two notations to refer a column of a table with a dot "." syntax, as shown below
  •  some_id of emp.empno%rowtype or (mirror of reference data type)
  • some_id of emp.empno%type ( mirror of reference data type)

Below is an example of  "%ROWTYPE" notation.

Script:

declare
type cs_idtype is table of emp.empno%type
index by binary_integer;
var_idtype cs_idtype;
i binary_integer :=0;
tcount binary_integer;
begin
dbms_output.enable;
for c_table in ( select empno from emp) loop
i := i + 1;
var_idtype(i) := c_table.empno;
end loop;
tcount := i;
for i in 1..tcount loop
dbms_output.put_line(' emp id ('|| to_char(i)||') ='||empno(i));
end loop;
end;
/

emp id (1) =7369
emp id (2) =7499
emp id (3) =7521
emp id (4) =7566
emp id (5) =7654
emp id (6) =7698
emp id (7) =7782
emp id (8) =7788
emp id (9) =7839
emp id (10) =7844
emp id (11) =7876
emp id (12) =7900
emp id (13) =7902
emp id (14) =7934