Create a Stored Procedure Interactively in Oracle

Q

How To Create a Procedure Interactively in Oracle?

✍: FYIcenter.com

A

If you want to create a stored procedure interactively, you can use the following steps:

  • Open you connection name, like Local_XE.
  • Right-click Procedures.
  • Select Create PROCEDURE. The Create Procedure window shows up.
  • Enter Name as: Hello
  • Click OK. The script area opens up with an empty procedure.
  • Place the empty template with the following procedure.
CREATE OR REPLACE PROCEDURE HR.HELLO AS
BEGIN
  DBMS_OUTPUT.PUT_LINE('Hello world!');
  DBMS_OUTPUT.PUT_LINE('Welcome to PL/SQL!');
END;

Click the Compile icon. The procedure is created.

 

Introduction to Oracle SQL Developer

⇒⇒Oracle Database Tutorials

2016-10-17, 183👍, 0💬