Home » SQL Developer » How to Edit Stored Procedure in Oracle SQL Developer?

How to Edit Stored Procedure in Oracle SQL Developer?

By

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: