You want to create a stored procedure using Oracle SQL Developer.
You can manually create a stored procedure by typing the code for creating your procedure into a SQL worksheet and executing it. You can also use the Create Procedure Wizard. To start the wizard, go to the File menu and select the New option. Once the Create a New dialog box opens (Figure 12-23), select Procedure.
Figure 12-23. Create a New dialog box
Once you click OK, you will be prompted to select a database connection. Doing so will open the Create PL/SQL Procedure Wizard. Alternatively, you can connect to the database of ...