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//删除部门信息
关于orcale的数据库脚本，记录下来，方便自己以后用到查找
原文：http://www.cnblogs.com/xiaoxiaomi/p/4933629.html