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 B as select * from table A;

simple Received on Tue Dec 07 2004 - 17:16:58 CST