Creating a new library

1.In the navigator, to create a library, select menu items File..New..PL/SQL library or select the Libraries node and then click on the Navigate.Create icon.

2.To create a program unit, expand the desired library node and select the Program Units node and then click Navigator..Create. A New Program Unit dialog appears.

3. Specify the Program Unit Name and its Type (Procedure, Function, Package Spec, or Package Body). Click on the OK button. The PL/SQL Editor is displayed.

4.In the PL/SQL Editor, describe appropriate program units and then click on Compile to compile and apply modification. Then Click on Close to close the editor.

5.Choose  Program..Compile..Incremental to compile any uncompiled library program units or click on Program..Compile..All for compile all library program units.

6. Click on File..Save to save the library module to a file or to the database.