https://blog.youkuaiyun.com/yanggoozh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/yanggoo/article/details/6065929https://blog.youkuaiyun.com/yanggoo/article/details/6065929yanggooThu, 09 Dec 2010 16:25:00 +0800需转换的内容中有双引号：
 
Replace（"/""，"a"）//  将双引号"转化为a
 
需要转换的内容有斜杠：
加上@
Replace(@"nyyadmin/web/",@"NewYp/CompanyDetail/CompanyDetail/companyPic/");]]>https://blog.youkuaiyun.com/yanggoo/article/details/6064946https://blog.youkuaiyun.com/yanggoo/article/details/6064946yanggooThu, 09 Dec 2010 11:00:00 +0800https://blog.youkuaiyun.com/yanggoo/article/details/6063928https://blog.youkuaiyun.com/yanggoo/article/details/6063928yanggooWed, 08 Dec 2010 20:24:00 +0800https://blog.youkuaiyun.com/yanggoo/article/details/6062854https://blog.youkuaiyun.com/yanggoo/article/details/6062854yanggooWed, 08 Dec 2010 13:43:00 +0800Create Or Replace Trigger delete_dept
After delete on dept
For each row
begin
  delete from type where type.deptname=:old.deptname;
  delete from emp where  emp.deptname=:old.deptname;
End delete_dept;]]>https://blog.youkuaiyun.com/yanggoo/article/details/6060555https://blog.youkuaiyun.com/yanggoo/article/details/6060555yanggooTue, 07 Dec 2010 14:01:00 +0800https://blog.youkuaiyun.com/yanggoo/article/details/6053029https://blog.youkuaiyun.com/yanggoo/article/details/6053029yanggooFri, 03 Dec 2010 15:06:00 +0800
oracle 多表删除 同时删除多表中关联数据

1、从数据表t1中把那些id值在数据表t2里有匹配的记录全删除掉
DELETE t1 FROM t1,t2 WHERE t1.id=t2.id    或DELETE FROM t1 USING t1,t2 WHERE t1.id=t2.id
2、从数据表t1里在数据表t2里没有匹配的记录查找出来并删除掉
DELETE t1 FROM t1 LEFT JOIN T2 ON t1.id=t]]>https://blog.youkuaiyun.com/yanggoo/article/details/6047204https://blog.youkuaiyun.com/yanggoo/article/details/6047204yanggooWed, 01 Dec 2010 11:00:00 +0800开始写博  要养成记录的习惯
]]>