PL/SQL : How would you do this ?

I accidentally updated EMP.JOB to 'BUSBOY' (all columns) [Quoted] But I have the previous result set saved in ascii like...

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ----- ---------- --------- ----- --------- ----- ----- ------

 7369 SMITH       HITMAN          7902  17-DEC-80    800           20
 7499 ALLEN      SALESMAN    7698  20-FEB-81   1600   300     30
 7521 WARD       SALESMAN   7698  22-FEB-81   1250   500     30
 7566 JONES      MANAGER     7839  02-APR-81   2975           20
 7654 MARTIN     SALESMAN   7698  28-SEP-81   1250  1400     30
 7698 BLAKE      MANAGER     7839  01-MAY-81   2850           30

On 8i, I put the JOB values and EMPNO values into collections, matching the orders,
and EXECUTE IMMEDIATE the updates in a loop. Works.

Is there a better way to restore these values back to it's original records ?
How about on V8 ?

thanks
jane Received on Wed Nov 21 2001 - 22:52:12 CET