luojunjun的博客

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;

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 ...