Output from multiple tables

Hi Can anyone help me with this,

I am trying to write a PL/SQL function that takes in id and updates all records with that id somewhere in them, throughout the database and sets a flag to Y. Now i have done this part but i also want to output to a file all the fields of all the records that now have this flag set to Y, is there a quick way to do this other than to go through each table and output the records one at a time.

Now i know this doesnt seem like a problem but i need each field of the record seperated like below and it would need about 200 lines of code to output the data like this the long way

id | something | flag | other id

Sorry just realised that is not very clear what i am really after is a query that looks something like this
Select *
From everytable in database
where flag = 'y'

is this possible?
Or does the old problems of joins get in the way (you can see i'm new to pl/sql)