Re: Copy a table within a db?

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