Uzytkownik "Sybrand Bakker" <gooiditweg@sybrandb.demon.nl> napisal w
wiadomosci news:9h9n60l0msl7u1j1h98325nr4cavsqq3ne@4ax.com...
> On 31 Mar 2004 21:07:05 -0800, vksingh_bhu@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