摘要:
get请求: 阅读全文
摘要:
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... 阅读全文
摘要:
1、首先,我们可以先建立自己的一个用户表空间,创建表空间的格式如下: create tablespace test(表空间的名字) datafile 'D:\oracle\product\10.2.0\userdata\test.dbf' (这边可以写成oracle的某个路径下)size 50m ( 阅读全文
摘要:
begin dbms_job.isubmit(24,'UPDATE_BUS_CAREER;',sysdate,'trunc(sysdate+1)+(10*60)/(24*60)'); end; begin dbms_job.remove(23); end; 阅读全文
摘要:
public String sendHttpMessage(String urlStr) { URL url = null; HttpURLConnection httpurlconnection = null; try { url = new URL(urlStr); // 以post方式请求 httpurlconnection = (Ht... 阅读全文
摘要:
package com.wondersgroup.kszx.util; import java.util.ArrayList; import java.util.List; import java.util.regex.Matcher; import java.util.regex.Pattern; public class IdCardUtil { private static ... 阅读全文
摘要:
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; --... 阅读全文
摘要:
sorter:function(a,b){ var pattenStr = new RegExp("\s|-| |:|/","g"); a = a.split(pattenStr); b = b.split(pattenStr); ... 阅读全文