xiaomifeng287的专栏

今天早晨打开alter_XX.log  。看了一下日志，发现了两个错误，昨天刚使用rman 的delete archivelog all，delete obsolete backup，把控制文件里面的日志记录删除和备份过期的文件删除，这个错也是昨天产生的。就想总结一下处理过程： 使用 cat /XXX/XXX/XXX/XXX/bdump/alter_zdtdb.log|grep -i or

--获取sql的执行计划以及统计信息，不显示查询信息SQL> set autotrace traceonly;SQL> select * from test;执行计划----------------------------------------------------------Plan hash value: 1357081020------------------

A表：select t.*, t.rowid from a t order by to_number(a1);   A1A2A3A4A5A6111A1A11222A2A11333A3A11441B1B11

一：语法(用法)：rank() over([partition by col1] order by col2) dense_rank() over([partition by col1] order by col2) row_number() over([partition by col1] order by col2) 其中[partition by col1]可省略。二

insert all        when a1='001' then into a1    when a1='002' then into a2    when a1='003' then into a3    when a1='004' then into a4    when a1='005' then into a5  select * from test; 

一、 start  with ... connect by priod 的使用方法介绍：   SQL> SELECT level, empno,ename,job,mgr FROM scott.emp START WITH ename = 'KING' CONNECT BY PRIOR empno = mgr; LEVEL EMPNO ENAME

SQL> select deptno,ename from emp; DEPTNO ENAME------ ---------- YODA 20 SMITH 30 ALLEN 30 WARD 20 JONES 30 MARTIN 30 BLAKE 10 CLARK 10 KING

oracle中使用正则：select distinct  regexp_instr('12345612345123',                             '123',                             LEVEL,                             1)  FROM DUAL WHERE regexp

select id, mc, sl, min(mc) keep(DENSE_RANK first ORDER BY sl) over(partition by id) a1,-- sl中最小中，取mc最小 max(mc) keep(DENSE_RANK last ORDER BY sl) over(partition by id) a2,--