PL/SQL As a bind variable to the cursor variable table?

For example announced in the section of the Declaration of the cursor:

Current_tab_cursor CURSOR IS SELECT * FROM emp;

and an empty variable of type table

TYPE emp_table_type IS TABLE OF emp%ROWTYPE
INDEX BY BINARY_INTEGER;

Question: how to create a variable table , so she was like, "emp_table_type" and the cursor reference to cursor "current_tab_cursor" ?
July 9th 19 at 10:46
1 answer
July 9th 19 at 10:48
Solution
You can load into the specified variable the whole sample of the tabular cursor or part of it, and then use the.

Find more questions by tags OracleSQL