Creating PL/SQL Functions, Procedures, and Packages

To create a PL/SQL function, procedure, or package:

Select View | Connection Navigator .
Expand Database and select a database connection.
In the connection, expand a schema.
Right-click a folder corresponding to the object type ( Procedures, Packages, Functions).
Choose New PL/SQL object_type. The Create PL/SQL dialog appears for the function, package, or procedure.
Enter a valid name for the function, package, or procedure and click OK.

A skeleton definition will be created and opened in the Code Editor. Edit the subprogram to define it.