Re: Resemble script for Oracle database

From: Noel <tbal_at_go2.pl>
Date: Thu, 1 Apr 2004 14:24:51 +0100
Message-ID: <c4h1e1$75v$1@inews.gazeta.pl>

Uzytkownik "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> napisal w wiadomosci news:9h9n60l0msl7u1j1h98325nr4cavsqq3ne_at_4ax.com...
> On 31 Mar 2004 21:07:05 -0800, vksingh_bhu_at_hotmail.com (vijay) wrote:
>
> >Hi,
> >SELECT * INTO ABC FROM XYZ
> >
> >Above script in SQL Server database does followings
> >1. Create ABC table if does not exist
> >2. Copy data from XYZ to ABC table
> >
> >What will be resemble script for Oracle database.
> >
> >Regards
> >Vijay
>
> Refer to 'CREATE TABLE .... AS SELECT'

also refer to 'INSERT INTO TABLE SELECT * FROM OTHERTABLE'.

--
TomekB

Received on Thu Apr 01 2004 - 07:24:51 CST