Oracle Insert from One Table to Another Table, Same Schema
I want to copy rows from one TableA, with over a million records, to anther TableB with identical column names, both in the same Schema. TableB is completely emply, but has several more columns, so in effect, TableA is a subset of TableB. How do I copy rows from Table A to the empty, Table B? Thanks.