SQL*Plus: Release 9.2.0.8.0 - Production on Mon Jun 11 16:12:50 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

SQL>   2    3    4    5    6    7    8

if [ $retcode -eq "0" ]; then
	print
	print "*******************************************************" 
  print "2) Updating records in SKU table"
  print "*******************************************************" 
	sqlplus $db_usr_stsc<<EOF
UPDATE stsc.sku s
SET (s.p_abc, s.p_manualparameters, s.p_commenttext, s.p_workinglistname) =
(SELECT x.p_abc, x.p_manualparameters, x.p_commenttext, x.p_workinglistname
      	       FROM pac.SKUUPDATE x
        	    WHERE s.loc = x.loc AND s.item = x.item)
 	WHERE EXISTS (SELECT 1
  	              FROM pac.SKUUPDATE x
    	           WHERE s.loc = x.loc AND s.item = x.item);
COMMIT;
exit
EOF
echo "Update Complete"
fi