摘要:
SELECT object_name, machine, s.sid, s.serial# FROM gv$locked_object l, dba_objects o, gv$session s WHERE l.object_id = o.object_id AND l.session_id = s.sid; alter system kill session '1132,15825';... 阅读全文
摘要:
CREATE OR REPLACE PROCEDURE merge_violationxdata_change IS v_id varchar2(50); cursor metaSrc_cursor is select guid from v_bcwzxx; begin open metaSrc_cursor; loop fetch metaSrc_cursor int... 阅读全文
摘要:
CREATE OR REPLACE Function IDCARD15TO18(CARD Varchar2) Return Varchar2 Is Type TIARRAY Is Table Of Integer; Type TCARRAY Is Table Of Char(1); RESULTS Varchar2(18); W TIARRAY; --... 阅读全文