Re: how to create a duplicate table using sql

db2group88_at_yahoo.com wrote:
> we are using oracle 10g. I would like to know if there is a sql command
> on oracle could allow to create a duplicate table. On DB2, we can do
> " create table B like table A", please advise. Thanks
>

create table t2 as select * From t1;

tahiti.oracle.com is where lives the docs which explain all concepts, incl. rudimentary ones. Good luck! Received on Tue Dec 07 2004 - 17:11:06 CST