Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Copy a record from 1-table to another

Re: Copy a record from 1-table to another

From: Thomas Kellerer <WVIJEVPANEHT_at_spammotel.com>
Date: Thu, 15 Dec 2005 01:03:52 +0100
Message-ID: <40bq78F19ph3jU1@individual.net>


JoeT wrote on 14.12.2005 23:43:
> Unfortunately, while this is A solution, I'm trying to avoid it.
> We are talking about well over 200-attributes in the table in the real
> system.
> All I want to do is copy R (which is over 200 attributes) to S which is
> the same structure with 3-additional attributes, and populate the
> 3-attributes when I do this.
>

I tend to believe that writing the posts for this group took you more time then it would have taken you to write down the select with the 200 columns :)

Thomas Received on Wed Dec 14 2005 - 18:03:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US