带参数的存储过程 及 SQL窗口执行procedure
带参数的存储过程
create or replace procedure p1(CTIME IN date) is
begin
***
exception
***
end;
SQL窗口执行多个存储过程:
begin
p1(to_date('20240219','YYYYMMDD'));
p2(to_date('20240220','YYYYMMDD'));
end;
带参数的存储过程
create or replace procedure p1(CTIME IN date) is
begin
***
exception
***
end;
SQL窗口执行多个存储过程:
begin
p1(to_date('20240219','YYYYMMDD'));
p2(to_date('20240220','YYYYMMDD'));
end;