title: PLSQL : How to save a dynamic SQL query result into a two dimension array?
body: <pre><code>CREATE TYPE VarArray AS VARRAY(50) OF VARCHAR2(50);
  
  CREATE TYPE VarAArray AS VARRAY(50) OF VarArray;
  
  Declare
     myTable VarAArray VarAArray();
     tableName Varchar2(50);
  Begin
    -- I want to save the data in the table of 'tableName' 
    -- into the myTable array, all the field values are 
    -- saved as varchar2 type
  End;
  </code></pre>
  
  <p>The key requirement of doing this is to get any of the filed value by row number and column id. Please feel free to offer better design options.</p>