delete from abc_zspmxx where zsxm_dm='03' and zspm_dm in('1111','1115','1116')
update abc_zspmxx set xh='3' where zsxm_dm='03' and zspm_dm='1112'
update abc_zspmxx set xh='4' where zsxm_dm='03' and zspm_dm='1113'
update abc_zspmxx set xh='5' where zsxm_dm='03' and zspm_dm='1114'
update abc_zspmxx set xh='8' where zsxm_dm='03' and zspm_dm='1108'
INSERT INTO ABC_ZSPMXX VALUES ('03','1117','aaaaa',1,null,'元','004',null,1,null,1,'01')
INSERT INTO ABC_ZSPMXX VALUES ('03','1118','bbbbb',3,null,'元','004',null,3,null,2,'01')
INSERT INTO ABC_ZSPMXX VALUES ('03','1119','ccccc',5,null,'元','004',null,5,null,6,'01')
INSERT INTO ABC_ZSPMXX VALUES ('03','1120','ddddd',4,null,'元','004',null,4,null,7,'01')
我现在要执行上面的这九条语句，能不能用一个sql脚本，或者用一个或多个更加优化的sql写出来
不要用存储过程和用JAVA代码写。在线等！！！
------解决方案--------------------
- SQL code
-- TRY IT..UPDATE ABC_ZSPMXX SET XH = DECODE(ZSPM_DM, '1112', '3', '1113', '4', '1114', '5', '1108', '8') WHERE ZSXM_DM = '03' AND ZSPM_DM IN ('1112', '1113', '1114', '1108');