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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Copy a table within a db?

Re: Copy a table within a db?

From: Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net>
Date: Sat, 04 Mar 2000 12:28:37 GMT
Message-ID: <Vj7w4.4746$vd7.181856@bgtnsc04-news.ops.worldnet.att.net>


Yes.

If you want to create the structure without the rows, add the following where clause

WHERE 1 = 2 Mark Lybarger <MarkLybarger_at_copper.net> wrote in message news:5mJv4.688$wE5.4398_at_newsfeed.slurp.net...
> does this load the table [MY_TABLE] with all the rows in
[SOME_OTHER_TABLE]?
>
>
> Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net> wrote in message
> news:Opjv4.4298$NO6.343536_at_bgtnsc06-news.ops.worldnet.att.net...
> > When you say copy, do you mean:
> >
> > CREATE TABLE MY_TABLE
> > AS SELECT *
> > FROM SOME_OTHER_TABLE
> > /
> >
> >
> >
> >
> >
> > <nmadson_at_my-deja.com> wrote in message
news:89kce7$gpr$1_at_nnrp1.deja.com...
> > > Is there any way to copy a table within a database other than creating
> > > a new table and then doing an INSERT INTO {}SELECT query?
> > >
> > > [I haven't gotten this far in my Oracle Basics class, but I would like
> > > to do this now :)]
> > >
> > > TIA,
> > > Nolan Madson
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
>
Received on Sat Mar 04 2000 - 06:28:37 CST

Original text of this message

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