Re: Resemble script for Oracle database

From: G Dahler <yellow-shark_at_spamex.com>
Date: Thu, 1 Apr 2004 10:12:30 -0500
Message-ID: <HjWac.17490$j57.935568@news20.bellglobal.com>

"Noel" <tbal_at_go2.pl> a écrit dans le message de news:c4h1e1$75v$1_at_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'.
> --

That does not create the table and presumes the table already exists.

I don't think there's a way in oracle to create the table if it does not exists. You either create the table OR insert in it. Received on Thu Apr 01 2004 - 09:12:30 CST