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 Command in SQL for Oracle 8 and up obsolete?

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

From: Tim Cross <tcross_at_pobox.une.edu.au>
Date: 20 Jun 2002 17:23:04 +1000
Message-ID: <87hejy2z3b.fsf@blind-bat.une.edu.au>


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

Original text of this message

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