How To Create a Procedure Interactively
Q
How To Create a Procedure Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer
✍: 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.
2007-04-28, 4638👍, 0💬
Related Topics: