Create a Simple Stored Procedure in Oracle

Q

How To Create a Stored Program Unit in Oracle?

✍: FYIcenter.com

A

If you want to create a stored program unit, you can use the CREATE PROCEDURE or FUNTION statement. The example script below creates a stored program unit:

SQL> set serveroutput on;

SQL> CREATE PROCEDURE Hello AS
  2  BEGIN
  3    DBMS_OUTPUT.PUT_LINE('Hello world!');
  4  END;
  5  /
Procedure created.

 

Introduction to Oracle PL/SQL

⇒⇒Oracle Database Tutorials

2016-10-16, 132👍, 0💬