Inserting Multiple Rows at a Time

In addition to adding values to a table one row at a time, you can also use a variation of the INSERT command to load some or all data from one table into another table. The second form of the INSERT command is used when you want to create a new table based on the results of a query against an existing table. The form of this INSERT command is:

     INSERT INTO table-name
       SELECT  expression1 [,expression2] ...
       FROM    table-name
       [WHERE  search-condition] ;

• Command Discussion