create and execute sql script in sqlplus
Posted on 2011-03-01
attention oracle dba's, i've got a lob ball question that yall can smash out of the park. I've got about 500 update statements aready formatted. example:
UPDATE KUAF SET NAME="AG:SERF:IND75951:GST" WHERE NAME="SERF-IND75951"
I just need to put all of these update statements in a correctly formatted sql script, and execute it via sql plus (with a log file piped to the file system).