A Real Dynamic Problem For Real Dynamic Developers!!
From: Jaboos <safena_at_hotmail.com>
Date: 6 Oct 2001 08:00:25 -0700
Message-ID: <220529d7.0110060700.41dde9a_at_posting.google.com>
Hi All,
[Quoted] I'm facing a real problem here, and I would be gratefull if someone can help me. The problem is as follows:
...
...
etc.
Date: 6 Oct 2001 08:00:25 -0700
Message-ID: <220529d7.0110060700.41dde9a_at_posting.google.com>
Hi All,
[Quoted] I'm facing a real problem here, and I would be gratefull if someone can help me. The problem is as follows:
- I'm having a database application consist of 180 (One Hundred Eighty) tables!
- 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!
[Quoted] 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 - 17:00:25 CEST