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" ?
1 answer
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