I was thinking that some kind of SQL-Delete/Insert would be in order, but I am not sure how to do this in Oracle. I think I want to do something like this:

1.
Read first row into memory variables
2.
Delete the row

3.
Insert the contents of memory into the table as a new row. The insert/update trigger would then fire and I would get all new columns populated.



If I was doing this in VFP (sorry but it's my main point of reference for database manip/programming) I would do something like:

scan
scatter memvar
gather memvar
endscan

And then the insert/update trigger would fire and the row would get populated.

Help?



>hi!
>easiest wasy migth be to just run an SQL script after the import.
>You can do this in a batch script or cron process very easily.
>
>i.e.
>imp blah/blah@sever file=c:\mydump.dmp full=y
>sqlplus blah/blah@server @c:\extrasql.sql
>
>Otherwise why not make an updated export file that contains the changed columns and trigger code.