09 2015 档案
摘要：where trunc(to_date(DATETIME,'yyyy-MM-dd hh24:mi:ss'))=trunc(sysdate)
阅读全文
摘要：DES 加密 有时会有 + = 这些特殊字符串Server.UrlDecode(Request["UserName"]) //能解决 = 号，但是 +号会变成空格HttpUtility.UrlEncode(Request["UserName"]); //能解决 +号 但是 =号还是 %3d/*由于D...
阅读全文
摘要：string yourhtml = @" "; string str = "http://www.baidu.com/"; yourhtml = Regex.Replace(yourhtml, @"(?i)(?]*?src=\...
阅读全文
摘要：SELECT REGEXP_SUBSTR(bjdm||',', '[^,]+', 1, LEVEL, 'i') AS STR,bjdm FROM valueWeekInfo CONNECT BY LEVEL /// 将某表的某列拆分成多行数据,返回的结构为 /// st...
阅读全文
摘要：Create Or Replace procedure loop_while_xlxxb( start_value in date, end_value in date)is current_value date:= start_value; current_djz number:=...
阅读全文
