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

Home -> Community -> Usenet -> c.d.o.server -> match columns on insert sub select

match columns on insert sub select

From: Dan. <dan_at_nospam.edu>
Date: Thu, 31 Jul 2003 10:21:11 -0700
Message-ID: <bgbj69$eok$1@news.Stanford.EDU>


Anyone know of an easy way to copy data from table to table that will match up exact same named columns from the source to the target?

TABLE1 (source)

FIELDA
FIELDB
FIELDC
FIELDD TABLE2 (target)

FIELDB
FIELDA
FIELDD
FIELDC
FIELDE
FIELDF
FIELDG A script would work but ideally it would be a keyword so you could do something like this?

INSERT INTO TABLE2
(SELECT MATCHING * FROM TABLE1)


instead of having to write out

INSERT INTO TABLE2
(SELECT

      FIELDB
      FIELDA
      FIELDD
      FIELDC
      '',
      '',
      ''
      FROM TABLE1)


Thanks for any responses,      -Dan
Received on Thu Jul 31 2003 - 12:21:11 CDT

Original text of this message

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