Oracle工作积累
augrush
是
展开
-
oracle角色权限,系统权限和对象权限
--角色权限select t2.n2, t2.grantee, substr(t2.str, 2) from (select rownum n2, t1.grantee, sys_connect_by_path(granted_role, ', ') str from (select rownum n1, t.* from dba_role_privs t) t1 where t1.n1 in (select max原创 2011-05-05 20:13:00 · 622 阅读 · 0 评论 -
Oracle行列转换
<br /><br />--行转列<br />select count(*) OVER() CNT, RN, STR<br /> from (select ROWNUM RN,<br /> SUBSTR(A.STR,<br /> INSTR(A.STR, ',', 1, A.N) + 1,<br /> INSTR(A.STR, ',', 1, A.N + 1) -<br />原创 2011-05-05 20:10:00 · 313 阅读 · 0 评论