Re: Copy Command in SQL for Oracle 8 and up obsolete?

Tim Cross wrote:

> drsmartz_at_yahoo.com (Andy) writes:
>
> > I have looked everywhere after reading in an Oracle 7 manual that the
> > copy command in version 8 and up of oracle will become obsolete.
> >
> > Is this a fact?
> > And if it is, is there another similar command I can use to copy all
> > fields from one table to another table?
> >
> Could you just use
>
> create table foo
> as select * from bar
>
> or
>
> insert into foo
> select * from bar
>
> ?
>
> Tim

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. ;-)

Daniel Morgan Received on Wed Jun 19 2002 - 18:25:30 CDT