1.PLSQL writing simple stored procedures (no parameters, plain printing)

First, open the SQL window in the database and write:

1 Create or Replace procedure Sayhellowworld-- new or replace Sayhellowworld,sayhellowworld as the method name, you can change your own 2  As3begin4 dbms_output.put_line (' Hello, world!  '); -- Use this package to greet, output text 5 End; 　 　　 　　 　　

Second, call the stored procedure

Method 1:

exec method name ();
Method 2:

Begin
Method name ();
Method name ();

...... (multiple calls can be called)

End

A.cmd Invocation Instance

　　

"Learning summary, for reference only"

1.PLSQL writing simple stored procedures (no parameters, plain printing)