Re: Resemble script for Oracle database

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 01 Apr 2004 07:19:11 +0200
Message-ID: <9h9n60l0msl7u1j1h98325nr4cavsqq3ne@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'

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Mar 31 2004 - 23:19:11 CST