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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement