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.

 

Execute a Simple Stored Procedure in Oracle

What Is a Stored Procedure in Oracle

Introduction to Oracle PL/SQL

⇑⇑ Oracle Database Tutorials

2019-03-20, 2670👍, 0💬