<div>
Oh really? &nbsp;I didn't know that. &nbsp;In Vertica, both work the same way. &nbsp;I will also test this out tomorrow. &nbsp;Thanks sdstuber. &nbsp;You help me a lot! :)
</div>


Oh really?  I didn't know that.  In Vertica, both work the same way.  I will also test this out tomorrow.  Thanks sdstuber.  You help me a lot! :)

<div>
INSERT INTO used when table exists, and SELECT INTO - when table does not exist<br />
<br />
<a href="http://www.blackwasp.co.uk/SQLSelectInsert.aspx" rel="ugc">http://www.blackwasp.co.uk/SQLSelectInsert.aspx</a>
</div>


INSERT INTO used when table exists, and SELECT INTO - when table does not exist

http://www.blackwasp.co.uk/SQLSelectInsert.aspx [http://www.blackwasp.co.uk/SQLSelectInsert.aspx]

<div>
YZlat, that was covered already yesterday
</div>


YZlat, that was covered already yesterday

<div>
@sdstuber, I think you are right.<br />
<br />
@YZlat, I tried to SELECT INTO a non-existing table, but it still failed. &nbsp;The following is my SQL.<br />
<br />
SELECT col1, col2 INTO table2 FROM table1;
</div>


@sdstuber, I think you are right.

@YZlat, I tried to SELECT INTO a non-existing table, but it still failed.  The following is my SQL.

SELECT col1, col2 INTO table2 FROM table1;

<div>
In pl/sql you could do<br />
<br />
SELECT * BULK COLLECT INTO tableA FROM tableB;<br />
<br />
if tableA is a collection, see the pl/sql guides in the oracle documentation for more info
</div>


In pl/sql you could do

SELECT * BULK COLLECT INTO tableA FROM tableB;

if tableA is a collection, see the pl/sql guides in the oracle documentation for more info

<div>
<div class="content wysiwyg-content">
SELECT * INTO tableA FROM tableB;<br />
<br />
INSERT INTO tableB SELECT * FROM tableA;<br />
<br />
Thanks.
</div>
</div>


SELECT * INTO tableA FROM tableB;

INSERT INTO tableB SELECT * FROM tableA;

Thanks.

Is there any difference between the following two statements in Oracle?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.