Use values from a column to run a SELECT statement Oracle

Use values from a column to run a SELECT statement Oracle

I need to iterate through column values in a query.
Table1
index value
1, Nice
2, School
3, Day
pseudocode:
FOR all values in Table1
SELECT parent, function(value)
from Table2