create procedure NOPROC(p_NONAME VARCHAR2,NOID_BACK INT OUTPUT varchar2) as begin update tabname set NOID=NOID+1,NOID_BACK:=NOID+1 where NONAME=p_noname and NODATE=TO_CHAR(SYSDATE,'YYYY-MM-DD'); if sql%rowcount=0 then NOID_BACK:=1; INSERT tabname VALUES(1,NONAME,TO_CHAR(SYSDATE,'YYYY-MM-DD')); end if; end; /
as
begin
update tabname set NOID=NOID+1,NOID_BACK:=NOID+1 where NONAME=p_noname and NODATE=TO_CHAR(SYSDATE,'YYYY-MM-DD');
if sql%rowcount=0 then
NOID_BACK:=1;
INSERT tabname VALUES(1,NONAME,TO_CHAR(SYSDATE,'YYYY-MM-DD'));
end if;
end;
/