FOR i IN tableName.FIRST..tableName.LAST LOOP
SELECT UOM_ID INTO varUomId
FROM tableName(i)
WHERE UOM_ID = 1
END LOOP;
---------------------------------------------------
I want to a get result from multiple tables by passing table name from an array. Pls help me