Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reducing coding of insert into.. select statement
"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