`` How to dynamically define variables in the program? ''

gangananren

In Oracle, how to dynamically define variables in the middle of a program to use when fetching data in a cursor. The number of variables to be defined and the type of the variable are unknown in advance.
But the number of variables and the type of variables can be found, `` How do you dynamically define these variables? ?

woshenming

declare cursor mycur is

  select * from table1;
  
m_mycur mycur%ROWTYPE;

After opening the cursor, use m_mycur.XX to become ~~

sevens

The variables to be defined are not necessarily all in one table

It may be a table

It may also be some fields in a table

There may be some fields in several tables

marceau543

You should have no way
Too many variables