From: morrisj@cableregina.com (Jason Morris)
Subject: Re: SELECT INTO
Date: 2000/05/05
Message-ID: <M%EQ4.6963$zRy1.4915235@tomcat.sk.sympatico.ca>#1/1
References: <3912E803.F12298AF@fast.no>
Content-Type: Text/Plain; charset=US-ASCII
X-Trace: tomcat.sk.sympatico.ca 957553772 142.165.202.49 (Fri, 05 May 2000 13:09:32 CST)
MIME-Version: 1.0
NNTP-Posting-Date: Fri, 05 May 2000 13:09:32 CST
Newsgroups: comp.databases.oracle.misc


On the other hand, if you're coming over from SQL Server, you can do this by:
CREATE TABLE myTable
AS SELECT * FROM ....

In article <3912E803.F12298AF@fast.no>, kevin.porter@fast.no says...
>
>Hi,
>
>How do I use SELECT INTO?
>
>I couldn't find an explanation on Oracle's site, please could someone
>give me a URL.
>
>thanks,
>
>- Kev
>