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.
⇒ Run Stored Procedures Interactively in Oracle
⇐ Export Data to an XML File in Oracle
2019-01-12, 2903🔥, 0💬
Related Topics:
