-
编辑 删除
oracle加密函数
Author: RainnyDate:2009-12-11create or replace function encrypt_md5(p_text varchar2) return varchar2 isbegin --添加RawToHex(UTL_RAW.CAST_TO_RAW())为得是加密后的输出数据规范些 --input_string必须要有，否则没有办法区分到底是调用那个md5 return RawToHex(UTL_RAW.CAST_TO_RAW(dbms_obfuscation_toolkit.MD5(input_string=>p_text)));end;[@more@]
-
编辑 删除
利用ORACLE正则表达式判断字符串是否为日期格式
Author: rainnyDate:2009-2-18CREATE OR REPLACE FUNCTION F_ISDATE( P_COLVALUE VARCHAR2, P_mandatory VARCHAR2) RETURN PLS_INTEGER IS v_cn PLS_INTEGER;BEGIN IF P_mandatory = 'yes' THEN IF P_COLVALUE IS NULL THEN RETURN 2; ELSE BEGIN SELECT 1 INTO V_CN FROM DUAL WHERE REGEXP_LIKE(P_COLVALUE, '^[1-9][[:digit:]]{3}-[[:digit:]]{1,2}-[[:digit:]]{1,2}$') AND NOT REGEXP_LIKE(P_COLVALUE, '^[1-9][[:digit:]]{3}-((00|0)-((00|0)|[[:di
-
编辑 删除
SQL SERVER和ORACLE的排序问题
SQL SERVER和ORACLE的排序问题 Author:Rainny Zhong Date: 2007-9-18一,SQL SERVER的排序问题SQL SERVER的排序由COLLATION指定.首先我们明白什么是COLLATION?COLLATION: The physical storage of character strings in Microsoft® SQL Server™ 2000 is controlled by collations. A collation specifies the bit patterns that represent each character and the rules by which characters are sorted and compared.也就是说COLLAT
