Hi all,
I'm trying to write a select statement in a LOOP that would select from a variable instead of a table, for example:
if i have a variable called my_var contains a value 'SCHOOL_LIST' (which is a table name in the database)

how can I write a select statement so that the below would work:

Select schoolname from my_var;

(the variable is being populated via a cursor)

plse help me ..Thanks