SQL Statements › INSERT › Example 2

Example 2

Load the temporary table TEMPEMP with data from table EMP.

      INSERT INTO SMITH.TEMPEMP
           SELECT *
           FROM EMP