Trying to write a stored procedure that will work on a table structure without knowing which specific table we are working on. Since we need to scan through a set of the records, i'm trying to build a cursor as
cursor MonthResidential is select * from lcTableName
where lcTableName is a variable holding the table name.
I'm able to use DBMS_SQL to create, populate and index this table, but need to scan through it to perform some calculations and generate an output file.
how can i build this cursor with the information i have?