![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
luojunjun
这个作者很懒,什么都没留下…
展开
-
oracle proc 死锁的sql及kill
select * from v$session a ,v$locked_object b ,dba_objects c where a.sid = b.session_id and b.object_id = c.object_id and a.username = 'NOVA' alter system kill session '152,41451' immediate;原创 2012-06-21 15:04:22 · 100 阅读 · 0 评论 -
切割字符串函数
CREATE OR REPLACE TYPE table_userid is table of varchar2(100); create or replace function get_userid_tab(v_str in varchar2) return table_userid pipelined as v_new_str varchar2(4000); begin ...原创 2012-07-20 21:24:22 · 121 阅读 · 0 评论