create [or replace]
procedure procedure name (parameters)
is
...
begin
...
end;
SQL>
SQL> create or replace procedure p_print(i_str1 VARCHAR2 :='hello',
2 i_str2 VARCHAR2 :='world',
3 i_end VARCHAR2 :='!' )
4 is
5 begin
6 DBMS_OUTPUT.put_line(i_str1||','||i_str2||i_end);
7 end;
8 /
Procedure created.
SQL>