Oracle
文章平均质量分 55
longxzq
这个作者很懒,什么都没留下…
展开
-
Oracle查询并删除重复记录的SQL语句
查询及删除重复记录的SQL语句 原文:http://maping.iteye.com/blog/3092951、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断 select * from people where peopleId in (select peopleId from people group by peopleId having count(...原创 2009-08-10 22:43:05 · 201 阅读 · 0 评论 -
ORACLE中的SQL%ROWCOUNT
ORACLE上的测试(数据库版本为:10G):1.创建数据库表: create table t( id int, name varchar2(50), address varchar2(100), primary key(id,name) ); 2.插入测试数据: insert into t (id,name,address) values (1,'yubowei'...原创 2010-02-03 14:10:49 · 307 阅读 · 0 评论 -
ORACLE SQL性能优化系列
ORACLE SQL性能优化系列: http://blog.csdn.net/baggio785/archive/2005/09/26/489625.aspx原创 2010-02-04 11:22:23 · 59 阅读 · 0 评论 -
[转]什么是savepoint?
什么是savepoint?Use the SAVEPOINT statement to identify a point in a transaction to which you can later roll back.例如: SQL> SELECT * FROM SCOTT.DEPT ;DEPTNO DNAME LOC------ -------------- --...原创 2011-08-28 09:40:51 · 142 阅读 · 0 评论