If you have an empty table named A ,and another table named B containing data
meeting the datatype of A,you can try the DML below:
insert into A (A.row1,A.row2,....)
select B.row01,B.row02,......
from B
where ......;
By the way,you can insert into the table with a PL/SQL procedure as well.
Where there is a will, there is a way.
|