-
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]
Santosh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|