create or replace function getglobalid return varchar2 is result varchar2(20); begin select to_char(sysdate, 'yyyymmdd') || lpad(seq_globalid.nextval, 11, '0') into result from dual; return(result); end getglobalid;
create or replace function getglobalid return varchar2 is result varchar2(20); begin select to_char(sysdate, 'yyyymmdd') ------解决思路---------------------- lpad(seq_globalid.nextval, 11, '0') into result from dual; return(result); end getglobalid;我怎么调用这个函数啊？取后面19位啊？刚接触oracel的function，请教大家
create or replace function getglobalid return varchar2 is result varchar2(20); begin select to_char(sysdate, 'yyyymmdd') ------解决思路---------------------- lpad(seq_globalid.nextval, 11, '0') into result from dual; return(result); end getglobalid;
