PL/SQL How to bind cursor variable to table variable?

Question

Oracle

Let's say the cursor is declared in the declaration section:
CURSOR current_tab_cursor IS SELECT * FROM emp;
and an empty table type variable
TYPE emp_table_type IS TABLE OF emp%ROWTYPE
INDEX BY BINARY_INTEGER;
Question: how to create a table variable so that it is of type "emp_table_type" and its cursor refers to the cursor "current_tab_cursor" ?

Answer 1

You can load the entire selection from the table cursor or part of it into the specified variable, and only then use it.