存储过程随机生成字符串、将long值格式化成字符串日期

一、随机生成字符串

先说随机生成数字、小写字母、大写字母组成的任意长度的字符串，这里所说的任意长度是指可以自定义，进行传参。贴代码：

</pre></p><p><pre name="code" class="sql">CREATE OR REPLACE FUNCTION get_uuid(len in int) RETURN VARCHAR2
as
result_ Varchar2(50);
sql_v varchar2(500);
begin
  with T AS(
  select chr(ascii('A')+ROWNUM-1) S from dual connect by rownum<=26
  UNION ALL
  select chr(ascii('a')+ROWNUM-1) S from dual connect by rownum<=26
  UNION ALL
  select chr(ascii('0')+ROWNUM-1) S from dual connect by rownum<=10
  )
  SELECT 
  REPLACE(TO_CHAR(WMSYS.WM_CONCAT(S)),',','') into result_
  FROM(
      select S,ROW_NUMBER()OVER(ORDER BY dbms_random.value) RN from T
  )WHERE RN<=len;
  dbms_output.put_line('++++++++++++++'||result_);
  RETURN result_;
end get_uuid;

二、将long值格式化成字符串日期

再说将long值转换成字符串日期，还是直接贴代码吧：

CREATE OR REPLACE FUNCTION getDateByHm(str IN varchar2) RETURN VARCHAR2
as
datestr Varchar2(50);
begin
  datestr :=TO_CHAR(str / (1000 * 60 * 60 * 24) +  
       TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS'), 'YYYY-MM-DD');
  RETURN datestr;
end getDateByHm;

写的不好，不喜勿喷！