oracle创建序列及主键生成策略

CREATE SEQUENCE emp_sequence --序列名
INCREMENT BY 1 -- 每次加几个 
START WITH 1 -- 从1开始计数 
NOMAXVALUE -- 不设置最大值 
NOCYCLE -- 一直累加，不循环 
CACHE 10;

select to_char(sysdate,'yyyymmdd')|| lpad(emp_sequence.nextval,6,'0') from dual

create or replace function get_postil_id return varchar2 is
  Result varchar2(14);
begin
declare
  m_str varchar2(14);
  begin
    select To_char(sysdate, 'yyyymmdd') || lpad(postilid.nextval, 6, '0')
      into m_str from dual;
    Result := m_str;


  end;


  return(Result);
end get_postil_id;