A Real Dynamic Problem For Real Dynamic Developers!!

From: Jaboos <safena_at_hotmail.com>
Date: 6 Oct 2001 12:09:04 -0700
Message-ID: <220529d7.0110061109.75469779@posting.google.com>

Hi All,
I'm facing a real problem here, and I would be gratefull if someone can help me. The problem is as follows:

1. I'm having a database application consist of 180 (One Hundred Eighty) tables!
2. There is a column that exist on each one of those 180 tables. This column called 'User_Name'.

My question is: How can I retreive the data from that column (User_Name) from all the 180 tables, using Reports or Forms (PL/SQL)? Or maybe using a single (sort of) query!

NB: It's tedious to write the same sql query for each of the 180 tables.

The result might look like this:

Table_Name                                 User_Name
----------------------------------------   ----------------------
Table_One                                  User_One
Table_Two                                  User_Two
Table_Three                                User_Three
Table_Four                                 User_Four

...
...

etc.

Best Regards,
Jaboos Received on Sat Oct 06 2001 - 14:09:04 CDT