title: Is there any way to use a PLSQL variable in 'FROM' clause?
body: <p>Hi Is there any way to use a PL sql variable in from clause?
  i am using below code but i am getting error in select statement that "Table Not Found"</p>
  
  <pre><code>declare 
  --var varchar2(20);
  cursor cur is
      select table_name from my_tables where table_name like 'RATED%';
      v_rows cur%rowtype;
  --V_name varchar2(20);
  begin
      open cur;
      loop
          fetch cur into v_rows;  
              exit when cur%NOTFOUND;
              select * from v_rows.table_name;  --here i am getting error.
     end loop;
   end;
  </code></pre>