Searching Oracle database

[Helen Moore <moorehh@JMU.EDU>]

Hi all,


We have recently upgraded our PeopleSoft Finance module from
version 5 to 6. In the last steps of the upgrade we noticed some
"old" data had not been converted (ie. from 3 to 5 characters). We
changed setid from 'JMU' to 'JMDSN'.
To make sure no old data exists out there we need to scan the tables
for the old value of 'JMU' in every field and every table.
Is there a quick and easy way of doing this? We are on a oracle/win95/
SQR3 environment.

Helen



Helen Moore
Senior Programmer Analyst
IT/IIS
James Madison University