run.sql

本人在工程上收集的比较常用的oracle sql语句 有问题请发email:[e-mail]

update no set city_id=212 where city_id=351;
update no set city_id=221 where city_id=352;
update no set city_id=221 where city_id=353;
update no set city_id=213 where city_id=354;
update no set city_id=216 where city_id=368;

update vlr set city_id=212 where city_id=351;
update vlr set city_id=221 where city_id=352;
update vlr set city_id=221 where city_id=353;
update vlr set city_id=213 where city_id=354;
update vlr set city_id=216 where city_id=368;

update city set name='阿拉善左旗' where name='阿拉山左旗';
update city set name='巴彦淖尔' where name='巴彦卓尔盟';
update city set name='呼伦贝尔' where name='海拉尔';
update city set name='乌兰察布' where name='乌兰查布盟';

delete from city where id in(351,352,353,354,368);
commit;
quit