Hello,
I'm a newbie on this forum and also on Oracle SQL, sorry if my question is too basic.
I'd appreciate any comment on the following:
I have tables T1, T2, ..., Tn.
Each one has a field F with different names (F1 for T1, F2 for T2 and so on) where a given value X is stored, but I don't know in what table.
Is it possible to create a single query that checks each of those fields of all tables at once? Or do I have to run a different select for each table?
Thank you in advance.
Marcelo