关于orcale的数据库脚本,记录下来,方便自己以后用到查找

delete from userinfo where userinfo guid in (select guid from personinfo where departid = 部门id);//删除人员信息
delete from personinfo where departid = 部门id;//删除用户信息
delete from UNITORGANIZATION where departid = 部门id//删除部门信息

 

posted on 2015-11-03 16:41  summer_I_summer  阅读(229)  评论(0编辑  收藏  举报