I have migrated a table from an existing Access system and I need to copy a part of this table to another.
EX: The existing (Access)table (Table A)had a product name and product number (among other things). In my new table, (Table B), I only need the product name from that table. The other columns in the new Oracle table (B) were not in the Access table (A).
How do I insert only the product name from table A into table B.