oracle数据库
冬夜听雪
爱好运动
展开
-
oracle数据库表空间的统计和添加
1.登录DBA用户,先统计表空间SELECT T.TABLESPACE_NAME, TO_CHAR((T.TOTAL_SPACE - nvl(F.FREE_SPACE,0)), '9999,999') "USED(M)", TO_CHAR(nvl(F.FREE_SPACE,0), '9999,999') "FREE(M)", TO_CHAR(T.原创 2017-04-21 16:28:32 · 256 阅读 · 0 评论 -
查询和删除表中重复数据sql语句
1、查询表中重复数据。select * from peoplewhere peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid最小的记录d原创 2017-04-21 16:34:37 · 234 阅读 · 0 评论