Re: A Real Dynamic Problem For Real Dynamic Developers!!

From: Ban Spam <ban-spam_at_operamail.com>
Date: Sat, 06 Oct 2001 19:28:42 GMT
Message-ID: <Xns91327EEF1FF06SunnySD@24.0.3.73>

safena_at_hotmail.com (Jaboos) wrote in news: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.
>

Yes, but you only have to write once. ;-) I suggest you consider using "dynamic SQL" from within a PL/SQL procedure.

HTH & YMMV! Received on Sat Oct 06 2001 - 14:28:42 CDT