使用时间戳和sequence生成主键的function

create or replace function fn_getKey
return varchar2
is
  k varchar2(30);
begin
  select to_char(sysdate, 'yyyymmddhh24miss') ||'-'|| seq_test.nextval into k from dual;
  return k;
end;

上一篇:连报三错


下一篇:linux find文档