使用时间戳和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;

posted @ 2015-09-24 13:36  也猫不要吃鱼  阅读(774)  评论(0编辑  收藏  举报