摘要:
算是一个工具吧,处理死锁问题--查询死锁SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK',NULL) LOCK_LEVEL,o.owner,o.object_name,o.object_type,s.sid,s.serial#,s.terminal,s.machine,s.program,s.osuser from V$lock l,dba_objects o,V$session sWHERE l.sid = s.sidAND 阅读全文
摘要:
语法格式:row_number() over(partition by 分组列 order by排序列 desc)一个很简单的例子1,先做好准备create table test1( id varchar(4) not null, name varchar(10) null, age varchar(10) null);select * from test1;insert into test1(id,name,age) values(1,'a',10);insert into test1(id,name,age) values(1,'a2',11);inse.. 阅读全文