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_at_hotmail.com>

[Quoted] Is the ff. possible?

[Quoted] 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);

[Quoted] 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 Wed Sep 29 1999 - 04:28:47 CEST