Copying part of a table to another

Hi,

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.

Hi

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;

Regards

[Edited by santoshym on 08-13-2001 at 10:47 AM]