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