![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
zhou_xhua
这个作者很懒,什么都没留下…
展开
-
oracle对date类型进行模糊查询
to_char(date,'yyyy-MM-dd HH24:MI:SS') like '%2009%'2009-09-25 13:27:19 · 813 阅读 · 0 评论 -
删除数据库中重复记录
delete from cims_projects_users_roles a where rowid not in (select min(b.rowid) from cims_projects_users_roles b where a.cims_projects_id=b.cims_projects_id and a.cims_users_id = b.cims_users_id and...2009-09-30 09:28:40 · 100 阅读 · 0 评论