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.
You can use the following statement
create table b as select productname from a;
If the table allready exists you can use the following statement
insert into b(productname) select productname from a;
[Edited by santoshym on 08-13-2001 at 10:47 AM]
Click Here to Expand Forum to Full Width