Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Copy Command in SQL for Oracle 8 and up obsolete?
Daniel Morgan <dmorgan_at_exesolutions.com> writes:
> > Could you just use
> >
> > create table foo
> > as select * from bar
> >
> > or
> >
> > insert into foo
> > select * from bar
> >
> > ?
> >
> And if you don't want the data too:
>
> CREATE TABLE fu AS
> SELECT *
> FROM bar
> WHERE 1 = 2;
>
> It's fubar ... not foobar. But then if you weren't there you might not
> know. ;-)
>
Oops - I probably came close to f* it up beyond all recognition!
Just another SNAFU I guess!
Tim Received on Thu Jun 20 2002 - 02:23:04 CDT