ORACLE PROCEDURE PRACTICE

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;