create or replace procedure AAA
(RESULT OUT VARCHAR2)
ASTEMP1 VARCHAR2(10);
TEMP2 VARCHAR2(4);BEGIN
select lpad(sequence.nextval,6,'0') into temp1 from dual;
select to_char(sysdate,'yy') into temp2 from dual;
result:=temp1||temp2;
END;
(RESULT OUT VARCHAR2)
ASTEMP1 VARCHAR2(10);
TEMP2 VARCHAR2(4);BEGIN
select lpad(sequence.nextval,6,'0') into temp1 from dual;
select to_char(sysdate,'yy') into temp2 from dual;
result:=temp1||temp2;
END;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货