Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to create a duplicate table using sql

Re: how to create a duplicate table using sql

From: Pedro Lopes <pedro.lopes_at_netvisao.pt>
Date: Tue, 07 Dec 2004 23:16:58 +0000
Message-ID: <newscache$dikd8i$4z7$1@newsfront4.netvisao.pt>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US