Re: Can you pass a table name into a stored procedure?

On 8 Dec 2005 08:03:12 -0800, "dean" <deanbrown3d_at_yahoo.com> wrote:

>
>However, I did try you method Malcolm, in fact I had in mind to try a
>union at some point anyway, and it does work. However, although its
>fast enough doing counts, I think we would lose all indexes on
>individual tables if we we try joining to them. This works, anyway:

It also demonstrates you can merge the various tables into one, as every table has a column tab_num with a default value of the table number.
You should get right of the distinct tables asap. And, BTW, if they have been properly set up, you won't loose indexes.

--
Sybrand Bakker, Senior Oracle DBA