oracle行列字符串
SELECT T.USER_NO,
T.USER_NAME,
MAX(SUBSTR(SYS_CONNECT_BY_PATH(T.ROLE_NAME, '/'), 2))
from (SELECT T.USER_NO,
T.USER_NAME,
T.ROLE_NAME,
T.USER_NO || ROW_NUMBER() OVER(PARTITION BY T.USER_NO ORDER BY T.USER_NO, LENGTH(T.ROLE_NAME)) RN,
T.USER_NO ||
(ROW_NUMBER() OVER(PARTITION BY T.USER_NO ORDER BY T.USER_NO,
LENGTH(T.ROLE_NAME)) + 1) RN_DOWN
from AAAAA T
) T
START WITH RN LIKE '%1'
CONNECT BY RN = PRIOR RN_DOWN
GROUP BY T.USER_NO, T.USER_NAME
ORDER BY T.USER_NO
---原本数据
---转换后的数据
相关文档：
通过 select * from table whereid=16701 for update 锁住一张表
通过以下语句可查询出被锁住的对象
SELECT OBJECT_ID,
SESSION_ID,
SERIAL#,
ORACLE_USERNAME,
&nb ......
CREATE OR REPLACE PROCEDURE kevin_proc(x varchar) IS
a VARCHAR(20);
b VARCHAR(20);
CURSOR mycur(rn NUMBER) IS SELECT * from t_kevin_test WHERE ROWNUM<rn;
BEGIN
OPEN mycur(10);
LOOP FETCH mycur INTO a,b;
EXIT WHEN mycur%NOTFOUND;
Dbms_Output.put_line('a: '||a);
Dbms_Output.put_line('b: '| ......
Oracle 数据类型及存储方式
袁光东 原创
概述
通过实例，全面而深入的分析oralce的基本数据类型及它们的存储方式。以ORACLE 10G为基础，介绍oralce
10g引入的新的数据类型。让你对or ......
2010-04-21 14:04
oracle中构造数组的例子：
declare
type t_varray is varray(4) of number;
arr t_varray;
begin
arr := t_varray(1,2,3,4);
for i in 1..arr.count loop
dbms_output.put_line(arr(i));
end loop;
end;
构造二维数组的例子：
declare
type t_varray ......
ORACLE实例有系统全局区（SGA）和一些后台进程组成.
系统全局区（SGA）有共享池（shared pool）,数据库高速缓冲区（database buffer cache）,重做日志缓冲区（redo log buffer）.共享池又有库高速缓存（library cache）和数据字典高速缓存（dictionary cache）组成。
ORACLE 实例5个必需的后台进程：SMON,PMON,DBWR,LGWR, ......
