FIRST PROCEDURE:
create or replace
procedure test_procedure_name
(
stat_date IN DATE DEFAULT TRUNC(SYSDATE -1),
P_OWNER IN VARCHAR2
)
as
begin
dbms_output.put_line('SYSDATE IS :' || stat_date || P_OWNER);
end test_procedure_name;
FIRST PROCEDURE:
create or replace
procedure test_procedure_name
(
stat_date IN DATE DEFAULT TRUNC(SYSDATE -1),
P_OWNER IN VARCHAR2
)
as
begin
dbms_output.put_line('SYSDATE IS :' || stat_date || P_OWNER);
end test_procedure_name;