blackfunk_at_verizon.net wrote:
> Hi,
>
> I have a file of data for a table without enough columns. So, i have
> to create another row to completely import the data for one row. I
> know the logical step is to create more columns but I cannot for other
> reasons. So, here is what I am doing:
>
> append
> into table x
> column a sequence (max,1)
> column b pos 1:3
> column c pos 4:6
> column d pos 7:9
> into table x
> column a sequence (max,2)
> column b pos 13:14,
> column c pos 15:16
>
> I am trying to grab data in another part of the record and insert it
> into the same column as the initial insert. The problem is column a is
> the primary key and I keep getting unique constraint errors. So, I am
> trying to figure out is there an option that allows the first into to
> completely finish its inserts and then attacks the second into
> statement OR do I create a sequence and use the nextval attribute for
> both INTO's. Please help, I am stuck. Thx.
How about just not mapping the data you don't want to insert?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Sep 29 2007 - 10:25:43 CDT
