Copying part of a table to another
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Copying part of a table to another

  1. #1
    Join Date
    Mar 2001
    Posts
    82
    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.

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    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
  •  


Click Here to Expand Forum to Full Width