May be the mechanism utilized in multiple insertion of rows within the table through single totally just like those of placing single row having a single query.Otherwise what's the exact mechanism?

If you're fetching the information from a current table, you should use INSERT INTO TABLE3 ( SELECT * FROM TABLE1 UNION SELECT * FROM TABLE2 ....) to fetch and place the information in one go.


SQL> SELECT * FROM SCOTT.EMP WHERE JOB = 'ANALYST1';

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO GENDER
---------- ---------- --------- ---------- --------- ---------- ---------- ---------- --------
      8909 LUTHAR     ANALYST1        7698 22-JUL-99       1232        788         50 F
      8999 AMAN       ANALYST1        7698 22-JUL-99       8569        788         50 M
      7788 SCOTT      ANALYST1        7566 19-APR-87       3000        150            M
      7902 2          ANALYST1        7566 03-DEC-81       3000                       M


SQL> SELECT * FROM SCOTT.EMP WHERE JOB = 'MANAGER';

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO GENDER
---------- ---------- --------- ---------- --------- ---------- ---------- ---------- ---------
      7566 5          MANAGER         7839 02-APR-81       2975        150            F
      7698 10000      MANAGER         7839 01-MAY-81       2850        150            F
      7782 CLARK      MANAGER         7839 09-JUN-81       2450        150            F

SQL> CREATE TABLE EMP1 AS ( SELECT * FROM SCOTT.EMP WHERE 1=2);

Table created.

SQL> SELECT * FROM EMP1;

no rows selected

SQL> INSERT INTO EMP1 ( SELECT * FROM SCOTT.EMP WHERE JOB = 'ANALYST1'
  2  UNION
  3  SELECT * FROM SCOTT.EMP WHERE JOB = 'MANAGER');

7 rows created.

SQL> SELECT * FROM EMP1;
     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO GENDER
---------- ---------- --------- ---------- --------- ---------- ---------- ---------- --------
      7566 5          MANAGER         7839 02-APR-81       2975        150            F
      7698 10000      MANAGER         7839 01-MAY-81       2850        150            F
      7782 CLARK      MANAGER         7839 09-JUN-81       2450        150            F
      7788 SCOTT      ANALYST1        7566 19-APR-87       3000        150            M
      7902 2          ANALYST1        7566 03-DEC-81       3000                       M
      8909 LUTHAR     ANALYST1        7698 22-JUL-99       1232        788         50 F
      8999 AMAN       ANALYST1        7698 22-JUL-99       8569        788         50 M

7 rows selected.

You are able to chain many SQL claims in one Oracle query by separating each SQL command having a semicolon. For example: Place INTO table VALUES(1,2) Place INTO table VALUES(3,4)