谢谢各位大虾,我试了是exec deletealltable CREATE function getsysdate(adddays number) return date is aa date; begin select sysdate into aa from sys.dual; return aa; end getsysdate; 再看看下面这个函数如何调用 exec getsysdate(1)出错!
select getsysdate(1) from dual;
函数带返回值,在过程中调用,要有变量的引用,直接在sqlplus中调用如上。
set serveroutput on DECLARE RetVal number; BEGIN RetVal := PMEXP.Testzyz; dbms_output.put_line('i' || RetVal || ';'); END;
CREATE function getsysdate(adddays number) return date
is
aa date;
begin
select sysdate into aa from sys.dual;
return aa;
end getsysdate;
再看看下面这个函数如何调用
exec getsysdate(1)出错!
DECLARE
RetVal number;
BEGIN
RetVal := PMEXP.Testzyz;
dbms_output.put_line('i' || RetVal || ';');
END;