There is no difference (until 12c), stored is there in the opposite of anonymous PL/SQL block which is not stored.

• DECLARE
  - marks the beginning of the declaration section
• procedure p2 is begin null; end;
  - this is a "private" procedure (private that this anonymous PL/SQL block). It does nothing (NULL), but the basic syntax is satisfied - it has its name, begin and end, and at least one command in between. It is not accessible outside of this PL/SQL block (the final example Michel provided)
• BEGIN
  - let's go!
• p2;
  - call the private procedure whose name is p2
• p;
  - call a stored procedure (Michel created it at the beginning of his example)
• END;
  - The End

but may i get proper syntax please.

i am not able to understand why did he put "end;" before begin .

procedure p2 is begin null; end;
- this is a "private" procedure (private that this anonymous PL/SQL block). It does nothing (NULL), but the basic syntax is satisfied - it has its name, begin and end, and at least one command in between.

if i get the syntax then i will be able to understand it properly. Thanks

declare
   --local procedure declaration
    procedure procname (parameters) is
      --variable declarations
    begin
       statements;
    end;
begin
   statements;
end;