How to Edit Stored Procedure in Oracle SQL Developer?

Follow these steps to edit stored procedure in Oracle SQL Developer.

1. In Oracle SQL Developer, click on the Schema to expand the node on the left side.
2. Then click on the Procedure node to expand.
3. List of Stored Procedure will display.
4. Then click on the procedure name which you want to edit.
5. It will open on the right side pane in SQL editor window.
6. There you can make the changes and click on the Gear icon to compile.

See also:

• How to Export Data From Oracle SQL Developer to Excel
• How to Create PK from Sequence Trigger in Oracle SQL Developer