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 -> Re: Reducing coding of insert into.. select statement

Re: Reducing coding of insert into.. select statement

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 3 Mar 2006 08:38:25 -0500
Message-ID: <q7CdnQpB5YdJ25XZRVn-og@comcast.com>

"Jeremy" <jeremy0505_at_gmail.com> wrote in message news:MPG.1e725007d54f327098a104_at_news.individual.net...
: In article <p9ydnXnZo57joJXZnZ2dnUVZ_tudnZ2d_at_comcast.com>, Mark C. Stock
: says...
: >
:
: >
: > you could use the data dictionary to generate the script
: >
:
: Hi mark - I guess so - then edit the resultant script to alter the bits
: that need altering. Any examples of a "previously-used" script?
:
:
: --
:
: jeremy
: '01 Triumph Sprint ST in green
: _______________________________________
: jeremy0505 at gmail.com
:

no, but it should really be trivial and not require any editing -- especially if you've got a trigger on the target table assigning the pks

at any rate, your only variables are table name, db link name, and (perhaps) sequence name -- everything else is in USER_TAB_COLUMNS and USER_CONSTRAINTS/USER_CONS_COLUMNS (to identify the single-column PK or exception process multi-column PKs)

++ mcs Received on Fri Mar 03 2006 - 07:38:25 CST

Original text of this message

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