PL/SQL : How would you do this ?

From: jane <janeyiu_at_optonline.net>
Date: Wed, 21 Nov 2001 21:52:12 GMT
Message-ID: <gmVK7.4128$636.1200576@news02.optonline.net>

I want to solve this problem in PL/SQL

I accidentally updated EMP.JOB to 'BUSBOY' (all columns) 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 - 15:52:12 CST