<div>
INSERT INTO sometable ( col1, col2 ... )<br />
SELECT field1, field2... <br />
FROM emp;
</div>


INSERT INTO sometable ( col1, col2 ... )
SELECT field1, field2...
FROM emp;

<div>
&gt;I need 10 insert statement becuase there is 10 records in the table<br />
as you see from above suggestion, you will need 1 INSERT statement to copy all 10 records at 1 time...
</div>


>I need 10 insert statement becuase there is 10 records in the table
as you see from above suggestion, you will need 1 INSERT statement to copy all 10 records at 1 time...

<div>
Sujith and Nav you both are right. thanks for your help. Will share the ponits.<br />
<br />
Thanks<br />
--Victor
</div>


Sujith and Nav you both are right. thanks for your help. Will share the ponits.

Thanks
--Victor

<div>
<div class="content wysiwyg-content">
Hello gentlemen,<br />
<br />
I've emp table. By using &quot;SELECT statement, I need to create a INSERT statement for this. How do I do that?In other words I've 10 records in EMP table.I need to create INSERT statement using those values. <br />
<br />
I need 10 insert statement becuase there is 10 records in the table. Make sense....<br />
<br />
Thank you so much<br />
Victor
</div>
</div>


Hello gentlemen,

I've emp table. By using "SELECT statement, I need to create a INSERT statement for this. How do I do that?In other words I've 10 records in EMP table.I need to create INSERT statement using those values. 

I need 10 insert statement becuase there is 10 records in the table. Make sense....

Thank you so much
Victor

INSERT Statement by using SELECT

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.