数据查询类

 1.查询重复数据.

A.  SELECT  T.ID,T.SSJMC,COUNT(*) FROM  T_QX_QXXX T

     GROUP BY T.ID,T.SSJMC

     HAVING COUNT(*)>1    -- ID,SSJMC 重复. 

B.用ROWID 方法

SELECT * FROM T_QX_QXXX T

WHERE T.ROWID !=(SELECT MAX(T.ROWID) FROM T_QX_QXXX A

WHERE T.ID=A.ID AND T.SSJMC=A.SSJMC);-- 这个查询出来的结果可以直接用DEL 删除, (小批量数据)

  2.查询死锁. 

select  b.owner,b.object_name,a.session_id,a.locked_mode from

v$locked_object a ,bda_objects b

where b.object_id=a.object_id; --查询死锁. 

alter system kill session 'sid,serial#';--- 解锁.

 3.查询刚执行的SQL

  SELECT * FROM V$SQLAREA

or

select * from v$sqlarea t
where t.FIRST_LOAD_TIME like '%2011-11-01/11%'
order by t.FIRST_LOAD_TIME desc 

4.取长度

SELECT   LENGTH(TBR) FROM T_QX_QXXX  -字位数.

5. 显示一条数据。

SELECT *FROM A  WHERE ROWNUM='1'