--返回当前日期 create or replace procedure TestSystemProcedures(outSystemDaye out varchar ) is begin outSystemDaye := sysdate; end TestSystemProcedures;--测试代码create or replace procedure test(outSystemDaye out varchar ) is vSysdate varchar(10) ; begin TestSystemProcedures(vSysdate); DBMS_OUTPUT.PUT_LINE(vSysdate); end test;
--返回当前日期 create or replace procedure TestSystemProcedures(outSystemDaye out varchar ) is begin outSystemDaye := sysdate; end TestSystemProcedures;--测试代码create or replace procedure test(outSystemDaye out varchar ) is vSysdate varchar(10) ; begin TestSystemProcedures(vSysdate); DBMS_OUTPUT.PUT_LINE(vSysdate); end test;
select sysdate from dual;
create or replace procedure TestSystemProcedures(outSystemDaye out varchar ) is
begin
outSystemDaye := sysdate;
end TestSystemProcedures;--测试代码create or replace procedure test(outSystemDaye out varchar ) is vSysdate varchar(10) ;
begin
TestSystemProcedures(vSysdate);
DBMS_OUTPUT.PUT_LINE(vSysdate);
end test;
create or replace procedure TestSystemProcedures(outSystemDaye out varchar ) is
begin
outSystemDaye := sysdate;
end TestSystemProcedures;--测试代码create or replace procedure test(outSystemDaye out varchar ) is vSysdate varchar(10) ;
begin
TestSystemProcedures(vSysdate);
DBMS_OUTPUT.PUT_LINE(vSysdate);
end test;