Re: INSERT INTO......SELECT*FROM.

Might this idea be more convenient:

When you create table2, create view_2_to_1 which selects the list of columns from table2 excluding the date/time stamp.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Juan Carlos wrote in message <7nq5aq$rug$1_at_bgtnsc03.worldnet.att.net>...
>
>
>
>INSERT INTO TABLE1
>SELECT * FROM TABLE2
>/
>
>TABLE1 and TABLE2 are identical, except TABLE2 has one more column
>(date/time stamp column) so we get ORA-00913: too many values. Are we
>stuck with having to list each column in the SELECT clause, of which there
>are many and varying? We want to genericize it so it won't require
>maintenance as the database structure changes. TABLE2 will always mirror
>TABLE1 by regularly dropping/re-creating from TABLE1, but with the extra
>date/time stamp tacked on.
>
>Thanks!
>
>
>
>
Received on Thu Jul 29 1999 - 14:38:14 CDT