转售调用接口时生成的流水号

create  sequence REQUEST_NO_SEQ
minvalue 1
maxvalue 9999999999
start with 125
increment by 1
cache 20
cycle;

 create or replace function GET_REQUEST_NO_FUN  return varchar2 is
  REQUEST_NO varchar2(50);
  seq_num VARCHAR2(20);
  SYSTEM_NO varchar2(20);
  
begin
    select REQUEST_NO_SEQ.Nextval into seq_num from DUAL;
      SYSTEM_NO:=Trim(TO_CHAR('1000000000','0000000000'));
     if seq_num<=9999999999 THEN         
         REQUEST_NO:=Trim(TO_CHAR(seq_num,'0000000000'));
     end if;
    select SYSTEM_NO || TO_CHAR(SYSDATE,'YYYYMMDD')||REQUEST_NO into REQUEST_NO from DUAL;
 return REQUEST_NO;
end;