In an Oracle 10g database I want to run a SQL statement for multiple tables that all contain the same column. I know it can be done in PL/SQL using a cursor but would like to know if it can be done in standard SQL.
I am in affect wanting to run it for multiple tables in a FROM command. I don't know if this is possible.
What can you recommend?
FROM t1.item_type,t2.item_type,t3.item_type ... t50.item_type
WHERE *.item_type = 'XYZ';