Reference an arbitrary number of tables?

From: Jay <manongjay_at_hotmail.com>
Date: Tue, 28 Sep 1999 21:28:47 -0500
Message-ID: <37F1795F.BCE6F613@hotmail.com>

Is the ff. possible?

Suppose we have an arbitrary number of tables:

    create table foo_one (id NUMBER);
    create table foo_two (id NUMBER);
    create table foo_three (id NUMBER);

...

    create table foo_N (id NUMBER);

Then suppose we need to insert values into these tables:

    insert into foo_one(id) value(1);
    insert into foo_two(id) value(2);
    insert into foo_three(id) value(3);

...

    insert into foo_N(id) value(N);

Is it possible to create a stored procedure that will simplify the above insert for N number of tables??? If so how?

Thanks in advance. Received on Tue Sep 28 1999 - 21:28:47 CDT